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?
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.
Dig Deeper on Oracle database backup and recovery
-
![]()
How to perform a Big to Little Endian conversion in Oracle 8i
By: Brian Peasland
-
![]()
Migrating Oracle to Sun Solaris with Oracle Transportable Tablespaces
By: Brian Peasland
-
![]()
Large data migration from XML database to Oracle 10g
By: Brian Peasland
-
![]()
Migrate Oracle 10g database from Linux to AIX
By: Brian Peasland
Start the conversation
0 comments