HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Transfer data from DB2 to Oracle

Submitted by: @import:stackexchange-dba··
0
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?

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.