Ask the Expert

How to migrate 1.5 TB Oracle database from Solaris to AIX

I am a consultant in IT enterprise in Poland. We have a huge database (1.5 TB) on Solaris (Oracle 10g) and we want to migrate it to AIX -- is expdp the best solution? How does it work? What are the possible problems? Thank you.

    Requires Free Membership to View

Changing platforms in Oracle 10g leads me to two paths. One, using Data Pump (expdp) as suggested. Or, using Transportable Tablespaces (TTS). I like the TTS option for a 1.5 TB database since you can simply FTP your tablespace's datafiles to your new server and plug them in to the new database. The majority of the time is spent FTP'ing the files. With a database this size, Data Pump requires to you export the database's contents, FTP the dump file to the new server, and then import the dump file to the new database. This can be time-consuming.

Refer to the Oracle documentation for information on TTS.

The only downside of TTS is that it only copies tables and indexes. Any stored procedures, views, sequences, etc. need to be re-created in the destination database.

This was first published in August 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: