Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Migrate to base release first?

I would like to know how to migrate from Oracle8i (8.1.7.4.0) to Oracle9i (9.2.0.5.0). Do I have to first do a migration to the Oracle9i base release (9.2.0.1.0) and from here apply a patch (for 9.2.0.5.0)? Or is there a better way to do this task?

I would like to know how to migrate from Oracle8i (8.1.7.4.0) to Oracle9i (9.2.0.5.0). Do I have to first do a migration to the Oracle9i base release (9.2.0.1.0) and from here apply a patch (for 9.2.0.5.0)? Or is there a better way to do this task?

You can migrate your database directly from release 8.1.7.4 to 9.2.0.5. The Oracle9i Release 2 (9.2) Data Migration...

Guide contains a table to help you determine the migration path for your database.

You might want to consider migrating to the latest Oracle9i release which is currently 9.2.0.7, rather than 9.2.0.5. The basic steps are to install the Oracle 9.2 base release into a new ORACLE_HOME, patch it to whichever release you prefer and migrate your database from release 8.1.7.4.

This was last published in May 2006

Dig Deeper on Oracle database export, import and migration

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.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close