Oracle9i Database Migration Release 1 (9.0.1) Part Number A90191-02 |
|
This chapter guides you through the process of migrating an Oracle7 database to Oracle9i using Export/Import. This chapter covers the following topics:
Oracle9i Database Utilities for detailed information about using the Export and Import utilities.
See Also:
To migrate a database using Export/Import, complete the following three basic steps:
"Choose a Migration Method" and Oracle9i Database Utilities for information that can help you to evaluate the choice of Export/Import for migration.
See Also:
To migrate or upgrade a database, use the Export utility shipped with the release of the source database. After the export, the Import utility can copy the data from the export dump file into the target database. The target database must be created and operational before the Import utility can migrate the exported data into the target database.
For example, if you are migrating to release 9.0.1 from release 7.3, then use the Export utility for release 7.3.
To migrate, upgrade, or downgrade a database, use the Import utility shipped with the release of the target database. For example, if you are migrating to release 9.0.1 from release 7.3, then use the Import utility for release 9.0.1.
Refer to the following sources if you have additional options installed:
To migrate an Oracle7 or version 6 database using the Export/Import utilities, complete the following steps:
To ensure a consistent export, make sure the source database is not available for updates during and after the export. If the source database will be available to users for updates after the export, then, prior to making the source database available, put procedures in place to copy the changes made in the source database to the Oracle9i target database after the import is complete.
Oracle9i Database Administrator's Guide for information about creating an Oracle9i database.
See Also:
SYSDBA
privileges.
STARTUP
.
LOG
parameter to save the informational and error messages from the import session to a file.
Oracle9i Database Utilities and the Oracle9i server
See Also:
README.doc
file for error handling information.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|