Q

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.

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.
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

Dig deeper on Oracle database export, import and migration

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