The Oracle Database release to which you downgrade can be one release older, at the most. For example, if the current database is Oracle Database 11g Release 1 (11.1), then Oracle Database 10g Release 2 (10.2) is the only release supported for the downgrade.
Exporting Data From Release 11.1 and Importing Into Earlier Releases
| Export From | Import To | Export Version to Use | Import Version to Use |
|---|---|---|---|
| Release 11.1 | Release 10.2 | Data Pump Export Release 11.1 with | Data Pump Import Release 10.2 |
| Release 10.2 | Release 10.1 | Data Pump Export Release 10.2 with | Data Pump Import Release 10.1 |
To obtain a downward compatible dump file:
With Data Pump Export, use the current version's Data Pump Export utility, but set the VERSION parameter to the target older version.
Data Pump Import cannot read dump file sets created by a database version that is newer than the current database version, unless those dump file sets were created with the VERSION parameter set to the version of the target database. Therefore, the best way to perform a downgrade is to perform your Data Pump export with the VERSION parameter set to the version of the target database.
-
With original Export, run an older version of Export (exp) to produce a dump file that is compatible with the database version to which you want to downgrade. Then, run the target's original Import utility.
Original Export dump files 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. The following tables provide specific examples.
No comments:
Post a Comment