Originally posted by rotem_fo
Hi,
You need to extract data from Oracle and upload it to Sybase.
You can spool the data from sqlplus (rather slow) or you can use an unload utility such as BMC's Unload for Oracle (very expensive).
There is a free tool called granger unload (available at http://www.datatransformations.com/download.htm) and it is very helpfull.

Simply extract data from oracle tables and use the Sybase BCP utility to load the data.

Cheers,
R.
There is another third party product FastReader from WisdomForce. www.wisdomforce.com. FastReqaader allowing unload large oracle tables into text file and creates input for loaders like sql loader* or others. Hope it helps