This content has been marked as final. Show 2 replies
You could use the datamover export from your DB2 database, and datamover import in the Oracle database. I'm not a DB2 expert, but it seems the DB2 unload can easily be used as an input of an Oracle load such as SQL*Loader.
Of course, all needs to be installed upfront onto your target system (Ptools, database...)
Before you perform the export via data mover, make sure you have already executed and cleared the audits (SYSAUDIT, DDDAUDIT). Also must check if there is customized code, with SQL statements specific to DB2, which will obviously not work on Oracle.