Copy data of table from sybase to oracle

Hi,
 I have a table in Sybase with data in it, also I have the same table in Oracle DB without data in it.
how do I copy the data of the Sybase table to the Oracle table

thanks.
madmareAsked:
Who is Participating?
 
sathyagiriCommented:
You could write a sql command to do that, something like

select col1||','||col2||','||coln from <tname> ;

and spool the output into a text file.
0
 
MohanKNairCommented:
Oracle generic connectivity is a solution. Create an ODBC link to Sybase database. Using Oracle Heterogeneous services it is possible to link to Sybase schema from Oracle DB Link.

See this link for a worked out example for transferring data from Excel to Oracle via ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:9636653191842517523::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4406709207206#18830681837358
0
 
sathyagiriCommented:
Another way would be to create a comma separated list of your data from sysbase into a text file.
Then use SQLLOADER to load into ORACLE.
0
 
madmareAuthor Commented:
sathyagiri , how do I create comma separated list of data from sysbase into a text file ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.