I need to transfer schemas from an Oracle 12.1.0.2 Database to an Oracle 11.2 XE Database. According 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 fails with errors that the dump has version 12.
<ERROR DETAILS>
Any ideas what's wrong?