patternMinor
Transfer data from DB2 to Oracle
Viewed 0 times
fromdb2oracledatatransfer
Problem
I want to transfer data from an old DB2 system to a new Oracle database.
How should I go about doing this?
How should I go about doing this?
Solution
Another approach is to use the Oracle Gateway for DB2 which can be used to create an Oracle database link to the DB2 database. Then use a SQL script to "pull" all the data from each table in turn by
insert into oracle_table select * from db2_table@dblink;Code Snippets
insert into oracle_table select * from db2_table@dblink;Context
StackExchange Database Administrators Q#41629, answer score: 4
Revisions (0)
No revisions yet.