IBM DB2 to Oracle DB Data Migration
Any advice on the following
Migrate a DB2 Databse to a number of Oracle Databases as follows
Inventory Management on AS400 DB2 to Oracle eBS Database 19C
Flight Management on AS400 DB2 to own Oracle Database
Flight Operations on AS400 DB2 to own Oracle Database
Maintenance on AS400 DB2 to own Oracle Database
The main challenge is splitting out the Inventory related data in the AS400 DB2 database from the remainder of the DB2 data and putting the Inv Data (All DB Objects) into Oracle eBS DB and putting the remainder into own new Oracle DB. The overall application is being upgraded to a modern application but all legacy data needs to be retained.