Downgrading an Oracle Database
You can also use Data Pump to downgrade an Oracle Database; for example, move all data and metadata from Oracle 12.1 to a database using 11.2.0.3.
To achieve this goal, you need to obtain a downward compatible dump file by setting the export (expdp) parameter VERSION to 11.2.0.3 (the target database release) as shown in the following command:
$ expdp fcomunoz/alvarez@pdborcl directory=datapump dumpfile=version_full_06192013.dmp full=y version=11.2.0.3
Note
The import utility (impdp) cannot read dump files created by a later release unless it was created using the VERSION parameter to set the release number of the target database.
This is the error message I got when trying to import data exported from a 12.1.0 database ...
Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
