Manage Learn to apply best practices and optimize your operations.

How to migrate 1.5 TB Oracle database from Solaris to AIX

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?

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.

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 last published in August 2007

Dig Deeper on Oracle database backup and recovery



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.