<div>
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.<br />
<br />
See this link for a worked out example for transferring data from Excel to Oracle via ODBC<br />
<a href="http://asktom.oracle.com/pls/ask/f?p=4950:8:9636653191842517523::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4406709207206#18830681837358" rel="ugc nofollow">http://asktom.oracle.com/pls/ask/f?p=4950:8:9636653191842517523::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4406709207206#18830681837358</a><br />

</div>


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 [http://asktom.oracle.com/pls/ask/f?p=4950:8:9636653191842517523::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4406709207206#18830681837358]


<div>
Another way would be to create a comma separated list of your data from sysbase into a text file.<br />
Then use SQLLOADER to load into ORACLE.
</div>


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.

<div>
sathyagiri , how do I create comma separated list of data from sysbase into a text file ?
</div>


sathyagiri , how do I create comma separated list of data from sysbase into a text file ?

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp;I have a table in Sybase with data in it, also I have the same table in Oracle DB without data in it.<br />
how do I copy the data of the Sybase table to the Oracle table <br />
<br />
thanks.
</div>
</div>


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.

Copy data of table from sybase to oracle

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.