-
export table from ORACLE to SYBASE
Hello,
Can anyone please help me in exporting data from ORACLE 8.1 to Sybase 12.0. The table is in ORACLE & I want to transfer data to Sybase table.
Cheers.
-
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.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
-
-
-
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
-
Originally posted by rotem_fo
You can spool the data from sqlplus (rather slow) . . .
This is slow if you send the data across the network. You could perhaps run SQLPLUS on the server, or write files with UTL_FILE (no newtork layers getting in the way). But if the free utility fits the bill, no need.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|