Q

How to migrate 300GB Oracle database from Z/OS to AIX

I need to migrate the database (Oracle 8.1.7.4) 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.

I am working as an Oracle developer in a bank. I need to migrate the database (Oracle 8.1.7.4) 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.
This was last published in July 2007

Dig Deeper on Oracle database export, import and migration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close