Q

Upgrading from 8i to 10g with import utility

I would like to upgrade from 8.1.7 to 10g. How to use the import utility to import the 8i dump to the 10g database?

I would like to upgrade from 8.1.7 to 10g. How to use the import utility to import the 8i dump to the 10g database?

To use Oracle's export and import utilities to upgrade your database from 8i to 10g, follow these steps:

  • Install the Oracle 10g database software into a separate ORACLE_HOME.
  • Create a starter 10g database with the appropriate application tablespaces created.
  • Export the Oracle8i database.
  • Import the Oracle8i database into the newly created 10g database.

Be sure to test this process more than once in a non-production environment, and also ensure that the applications supported by your database are tested each time the upgrade is tested. For more information, refer to the Oracle 10g Database Release 2 Upgrade Guide.

Note that if your database is currently at release 8.1.7.4, a direct upgrade to 10g release 2 is supported. This method allows you to upgrade your database in place either using the DBUA (Database Upgrade Assistant) or manually using provided scripts. For more information on how to determine the best upgrade path for your situation, refer to the Upgrade Guide mentioned above.

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close