Q
Manage Learn to apply best practices and optimize your operations.

Exp/imp for complex cross-platform migration and upgrade

I have to migrate data from Oracle 7, Oracle 8i, Oracle RAC 9i to Oracle 10g on different operating systems. Can I do it with the exp/imp utility?

I have to migrate data from Oracle 7 (SCO UNIX), Oracle 8i (SCO UNIX), Oracle RAC 9i (HP-UX) to Oracle 10g (IBM AIX). Earlier I did it only with exp/imp utility. But now the databases are too large (1.5 HB in Oracle 7 to 50 HB in Oracle 8i, 9i). How to do it quickly? Expdb from 10g? RMAN? Please, give me some plan and corresponding articles.
Since you are going from such different platforms to a new OS, and from different versions to upgrading to 10g, your best bet is still the export and import utilites. Data Pump won't work here because it cannot be used for pre-10g databases.

Dig Deeper on Oracle database backup and recovery

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close