Ask the Expert

Migrating a database from an 8.0.5 server to a 9i server

I have an Oracle 8.0.5 server and a second with 9i. For the server, I have several databases. Now I have to migrate a database (8 GB) from the first to the second Oracle server. Thanks for your help.

    Requires Free Membership to View

It sounds like you have two separate machines, one with Oracle 8.0.5 and the other with Oracle 9.2 installed. Each database server has one or more databases. You wish to migrate one of your 8.0.5 databases to the other server and make it a 9.2 database. Because there is no direct upgrade path from Oracle 8.0.5 to 9.2, your choices are limited to using the export/import method or the CTAS (create table as select) via a database link. For both of these migration methods, you would create a basic Oracle 9.2 database on the server. Export the 8.0.5 database, FTP the dump file to the other server and then import into the 9.2 database. The process for using CTAS starts out the same in that you must create a basic 9.2 database. Create a database link from the 9.2 database to the 8.0.5 database, generate your 'create table as select' statements to copy over the data and then run them. Finally, remember to manually recreate indexes and constraints. The easiest of these two methods is to use export/import as this brings over data, indexes, packages/procedures and constraints with very little, if any, manual recreation of objects.

Further information on migrating to Oracle 9.2 can be found in the Oracle9i Database Migration Release 2 (9.2) Guide located on Oracle's Technology Network Web site.

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: