You can use Oracle's export and import utilities to migrate from Oracle 8.1.6 to 9.2.0. Since a direct upgrade from 8.1.6 is not supported, this is one of only a few choices available to you. The other option is to create a new 9.2.0 database, create a database link between the two databases, and use CTAS (create table as select) commands to move your data. This, however, usually requires more work and effort than using export and import...
since you must remember to re-create your constraints and indexes on the new database.
For more information on using export and import, read the Oracle9i Database Utilities Guide.
Dig deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.