Q

Database too large for import/export method of migration

We are currently running Oracle 9iR2 on Win2000 Server with multimaster replication configured, which includes two sides. Our company now wants to migrate to RHEL4 with the same Oracle version. The database is too large for import/export. Please suggest the least time-consuming process of migration.

We are currently running Oracle 9iR2 on Win2000 Server with multimaster replication configured, which includes two sides. Our company now wants to migrate to RHEL4 with the same Oracle version. The database is too large for import/export. Please suggest the least time-consuming process of migration. Is there any way that I can just do a cold backup and restore it on my RHEL4 server?

If you are planning to remain at the same version (9.2.x), then your choices are somewhat limited. You cannot use a cold backup to copy your database across platforms, even though both Windows and Linux are little endian platforms. If export/import will not work due to the size of the database, you could try using CTAS (create table as select …) over a database link. This does involve some manual work as you will then have to ensure...

that referential constraints, indexes, etc. are created after the fact. This, however, won't be any faster than using export/import.

If you attended IOUG Live! 2005 in May, you can download Richmond Shee's paper entitled "Pre-Oracle10g Data Migration to Linux Best Practices Using Export/Import" from the IOUG Web site. His paper and presentation are focused on tuning the import process so that the migration takes less time. It was a great presentation and his paper may prove quite helpful to you.

If you have the option of upgrading to Oracle 10g, there are more options available to you. One is Data Pump, and the other is transportable tablespace using RMAN.

A great resource is the Oracle Technology Network, where you will find many good articles on migrating to Linux.

This was first published in February 2006

Dig deeper on Oracle database export, import and migration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close