Transfer data from DB2 to Oracle I want to transfer data from an old DB2 system to a new Oracle database.

How should I go about doing this?
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;