I need to transfer schemas from a Oracle 12.1.0.2 Database to a Oracle 11.2 XE Database. Accodring to
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?