Q

Using export/import to upgrade to 9i Rel 2

Currently I'm using Oracle DB 8.1.6. I want to upgrade this to 9i Rel 2. Can I use export/import for this?

Currently I'm using Oracle DB 8.1.6. I want to upgrade this to 9i Rel 2. Can I use export/import for this?

You can use Oracle's export and import utilities to migrate from Oracle 8.1.6 to 9.2.0. Since a direct upgrade

from 8.1.6 is not supported, this is one of only a few choices available to you. The other option is to create a new 9.2.0 database, create a database link between the two databases, and use CTAS (create table as select) commands to move your data. This, however, usually requires more work and effort than using export and import since you must remember to re-create your constraints and indexes on the new database.

For more information on using export and import, read the Oracle9i Database Utilities Guide.

This was first published in June 2006

Dig deeper on Oracle database installation, upgrades and patches

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close