Oracle Datapump between different database releases

datapumporacle

I need to transfer schemas from a Oracle 12.1.0.2 Database to a Oracle 11.2 XE Database. Accodring to

Oracle Docs:

On a Data Pump export, if you specify a database version that is older
than the current database version, then a dump file set is created
that you can import into that older version of the database. For
example, if you are running Oracle Database 12c Release 1 (12.1.0.2)
and specify VERSION=11.2 on an export, then the dump file set that is
created can be imported into an Oracle 11.2 database

.

I used the following expdp command:

expdp system/XXXX directory=name dumpfile=dump_24.8.2018.dp consistent=y version=11.2 logfile=dump_24.8.2018.log schemas=name1,name2

The impdp failes with errors that the dump has version 12. Any ideas whats wrong?

Best Answer

Be sure to use the version 12 impdp to import into the Oracle 11.2 XE Database.