[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Copy data of table from sybase to oracle

Posted on 2006-06-26
6
Medium Priority
?
677 Views
Last Modified: 2009-07-29
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.
0
Comment
Question by:madmare
  • 2
4 Comments
 
LVL 16

Expert Comment

by:MohanKNair
ID: 16983203
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
 
LVL 14

Expert Comment

by:sathyagiri
ID: 16996975
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
 

Author Comment

by:madmare
ID: 16997780
sathyagiri , how do I create comma separated list of data from sysbase into a text file ?
0
 
LVL 14

Accepted Solution

by:
sathyagiri earned 2000 total points
ID: 16998074
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question