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