|Oracle® Database Upgrade Guide
10g Release 1 (10.1)
Part Number B10763-02
This chapter guides you through the process of using the Export and Import utilities to copy data from one Oracle Database to another in which the database release numbers are different. This chapter covers the following topics:
See Also:Oracle Database Utilities for detailed information about the Export and Import utilities
Note:This chapter discusses data copying using the original Export and Import utilities. Data Pump Export and Data Pump Import cannot be used in releases prior to Oracle Database 10g release 10.1.
Dump files created by the Export utility can be imported into all future releases of the Oracle Database. For example, an Oracle8 export dump file can be imported by the oracle8i, Oracle9i, and Oracle Database 10g Import utilities.
Export dump files, however, are not downward compatible with the Import utilities of previous Oracle Database releases. That is, exported data cannot be imported by the Import utilities of previous Oracle Database releases. For example, an Oracle9i export dump file cannot be imported by an Oracle8i Import utility, and an Oracle Database 10g export dump file cannot be imported by an Oracle9i Import utility.
Table 8-1 shows which Export and Import releases to use when moving data between different releases of the Oracle Database.
Table 8-1 Using Different Releases of Export and Import
|Export from||Import to||Use Export Utility for||Use Import Utility For|
|Release 10.1||Release 10.1||Release 10.1||Release 10.1|
|Release 10.1||Release 9.2||Release 9.2||Release 9.2|
|Release 10.1||Release 9.0.1||Release 9.0.1||Release 9.0.1|
|Release 10.1||Release 8.1.7||Release 8.1.7||Release 8.1.7|
|Release 10.1||Release 8.0.6||Release 8.0.6||Release 8.0.6|
|Release 9.2||Release 10.1||Release 9.2||Release 10.1|
|Release 8.1.7||Release 10.1||Release 8.1.7||Release 10.1|
|Release 8.0.6||Release 10.1||Release 8.0.6||Release 10.1|
|Release 7.3.4||Release 10.1||Release 7.3.4||Release 10.1|
When you export data to a previous release, data that is incompatible with the previous release either is not exported at all or is exported with the loss of some features. For example, the new floating point datatypes in Oracle Database 10g are not exported by the Oracle9i Export utility. In general, if you need to export data to a previous release, then first remove as many incompatibilities with the previous release as possible before you export the data.
To upgrade a database using the Export/Import utilities, complete the following steps:
Export data from the current database using the Export utility shipped with the current database. See the current database's utilities documents for information about using the Export utility on the current database.
To ensure a consistent export, make sure the current database is not available for updates during and after the export. If the current database will be available to users for updates after the export, then, prior to making the current database available, put procedures in place to copy the changes made in the current database to the new Oracle Database after the import is complete.
If the new Oracle Database will have the same name as the current database, then shut down the current database before creating the new Oracle Database.
Create the new Oracle Database.
See Also:Oracle Database Administrator's Guide for information about creating an Oracle Database
Start SQL*Plus in the new Oracle Database environment.
Connect to the database instance as a user with
Start an Oracle Database instance using
Pre-create tablespaces, users, and tables in the new database to improve space usage by changing storage parameters. When you pre-create tables using SQL*Plus, either run the database in the original database compatibility mode or make allowances for the specific data definition conversions that occur during import.
Note:If the new Oracle Database will be created on the same computer as the source database, and you do not want to overwrite the source database datafiles, then you must pre-create the tablespaces and specify
Use the Import utility of the new Oracle Database to import the objects exported from the current database. Include the
LOG parameter to save the informational and error messages from the import session to a file.
See Also:Oracle Database Utilities for a complete description of the Import utility.
After the import, check the import log file for information about which imports of which objects completed successfully and, if there were failures, which failed.
See Also:Oracle Database Utilities and the Oracle Database
Use further Import scenarios (see Oracle Database Utilities) or SQL scripts that create the database's objects to clean up incomplete imports (or possibly to start an entirely new import).
If changes are made to the current database after the export, then make sure those changes are propagated to the new Oracle Database prior to making it available to users. See Step 0 for more information.
Complete the procedures described in Chapter 4, "After Upgrading a Database".