If it can be done, it would be done by creating a database link in the Oracle database with the CREATE DATABASE LINK sql command. This also means you have to place an entry in your TNSNAMES.ORA file with all the appropriate paramters of the Sybase database. I know it can be done for a DB2 database, but I did that years ago and have forgotten all the details. Hopefully, this will get you started down the right path.
>HI,
>somebody told me that it is possible to retreive rows from Sybase using PL/SQL and insert them into an Oracle table? Maybe I am missing something here but I think that you need some kind of bridge (ODBC, ADO, SQL LOADER) in order to import rows from an outside source.
>
>Thank you,
>Christian Cote
Mark McCasland
Midlothian, TX USA