The information in this chapter only applies to release 8.0 and higher installations of Oracle. The term downgrading describes transforming an Oracle database into a previous release of the same version, such as transforming a database from release 8.1 to release 8.0. The term downgrading also describes transforming an Oracle database into a previous version, such as transforming a database from Oracle8i to Oracle7.
This chapter describes downgrading to Oracle7. If you want to downgrade to a previous 8.0 or 8.1 release, see Chapter 12.
This chapter covers the following topics:
An Oracle8i database can be downgraded to an Oracle7 database (such as release 7.3). However, few downgrade paths are available, and the necessary procedures may require a great deal of time and effort. Also, it may not be possible to preserve data that uses new version 8 features that are not available with Oracle7.
Oracle does not support downgrading from Oracle8i to Oracle7 using the Oracle8i Migration utility; in other words, the Oracle8i Migration utility does not support backward migration. Oracle8i provides no other facilities specifically for downgrading.
The procedure for downgrading depends on whether the Oracle8i database contains new or changed data that must be preserved. Use the procedure that applies to your Oracle8i database:
If the Oracle8i database contains no new or changed data that must be preserved, simply restore the complete backup of the previous Oracle7 source database and open it again. Make sure the restore includes the initialization parameters that were used in the previous Oracle7 database.
Any new or changed data in the release 8.1 database is lost when you use the method described in the previous paragraph. If your release 8.1 database has new or changed data that must be preserved, use the procedure described in "Downgrading a Database That Contains New or Changed Data".
If the Oracle8i database contains new or changed data that must be preserved, complete the procedure illustrated in Figure 13-1.
The following steps describe the procedure in more detail:
catexp7.sqlscript on the Oracle8i database. This script is in the
Several other methods are available for sending table data from the Oracle8i database back to the Oracle7 database. These methods of returning data to Oracle7 are relatively simple if only a few tables have been updated using Oracle8i. However, copying an entire database of tables can be a long and complicated task; therefore, you should decide whether you need to return to Oracle7 before you update many tables using Oracle8i.
The following alternate methods are available for downgrading an Oracle8i database to Oracle7: