Ask the Expert

Migrating from 8i to 9i without using the export/import method

How to migrate a database from Oracle 8i to 9i? I don't want to use the export/import method. My database size is more than 1 TB. Many thanks.

    Requires Free Membership to View

With a database that size, you will likely have to perform the migration in place. At a very high level, here are the steps you should follow:

  • Install Oracle 9.2 in its own ORACLE_HOME and patch it to 9.2.0.7
  • Use either the Database Upgrade Assistant (DBUA) or perform the migration manually to get your Oracle 8i database migrated to release 9.2.

The Oracle9i Database Migration Release 2 (9.2) Guide available on Oracle's Technology Network Web site provides very detailed instructions for migrating a database in place. Remember to test all applications supported by this database thoroughly before performing this migration in a production environment.

This was first published in October 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: