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?
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.
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments