Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extracting Tables

Status
Not open for further replies.

tonisyb

Technical User
Jun 19, 2002
7
ZA
I need to extract all the tables out of a Oracle database and import into a IBM DB2 Universal database Version 7 database running on Redhat. How do I go about doing this?

Thanks
 
It depends on how much data is in the Oracle database..

The basic method would be to output the data from each table into a comma-delimited file which the DB2 database may be able to read..( would require pre-creation of the tables in the DB2 database )

But, given the competition between the 2 companies, I would check with IBM about a data migration tool...

[profile]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top