Best option is to use bcp to get the data out of Sybase ino a flat file,
then use SQL*Loader to get the data into some Oracle staging tables. You can
then use pl/sql procs to move the data to it's final destination.
Ade
-Original Message-
Sent: 29 January 2003 12:49
To: Multiple recipient
vijay,
oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects & data from sybase to oracle.
however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you