I am working as an Oracle developer in a bank. I need to migrate the database (Oracle 188.8.131.52) on IBM Z/OS to Oracle 10g on IBM AIX Server. The size of the database is 300GB. Please let me know the best way to migrate. IBM Z/OS is not supporting a lot of new features of Oracle 10g including cross-platform tablespaces and external tables and even Data Pump. So I have a choice of export and import and copying the data over a link (this is not a good idea for such a large database). I want to know if there is any other way or should I go for export and import only.
If I was in this situation, I would use export/import for this migration. You are changing platforms, so your options are limited. Export/import is one option. You can copy the data over a link as suggested, but then you will also have to re-create the other database objects in the destination database. Export/import gets the data and the other objects as well. I would only copy the data over the link should I have a very small downtime window to complete the migration.
Dig Deeper on Oracle database export, import and migration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.