By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
I am working as an Oracle developer in a bank. I need to migrate the database (Oracle 22.214.171.124) 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.