Ask the Expert

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

I am working as an Oracle developer in a bank. I need to migrate the database (Oracle 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.

    Requires Free Membership to View

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 first published in July 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: