Q

Easiest way to migrate from Oracle 7i to Oracle 10g

What is the easiest way to migrate from Oracle 7i to Oracle 10g?

What is the easiest way to migrate from Oracle 7i to Oracle 10g? What are the restrictions and risks?

This is a significant upgrade path so there is really no "easy" way to do this. You cannot upgrade in place directly from Oracle 7 to 10gR2 so if you want to do the upgrade in one step, export and import is your best option. If you prefer to upgrade in place, according to the Oracle Database 10g Release 2 (10.2) Upgrade Guide, you will need to be at release 7.3.4, then you can upgrade to 8.1.7.4 and finally to Oracle 10gR2.

As mentioned, this is an enormous leap in database software technology so whatever option you choose, please ensure that you test the entire upgrade process from end to end in a non-production environment. There will likely be code changes to your applications, as well as some SQL tuning since the Oracle optimizer has changed dramatically from release 7.3.4 to 10.2. I'm assuming there is likely an operating system upgrade as part of this migration, too, so this will complicate the upgrade somewhat. If the database is not very large in physical size and you can take a reasonable outage to perform the upgrade, I would recommend using export and import. Export relevant schemas from the existing Oracle 7 database, and import them into the newly created Oracle 10gR2 database. You will still have to test thoroughly and likely make SQL and code changes, but at least this gets you to where you want to be in one big step, rather than two.

This was first published in April 2007

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