Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
I got this error while importing dump file:
ORA-39358: Export dump file version 12.2.0.1.0 not compatible with target version 11.2.0.4.0 .
SOLUTION:
First we check the compatible parameter of both source and target database.
1 2 3 4 5 6 | Source DB SQL> show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ---------------------------- compatible string 12.2.0.1.0 noncdb_compatible boolean FALSE |
1 2 3 4 5 6 7 | TARGET DB SQL> show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ----------------------------- compatible string 11.2.0.4.0 |
We can see the source compatible parameter is higher version(12.2.0.1) and target is lower(11.2.0.4).
A dump file generated from database with higher compatible parameter can’t be imported to a database with lower compatible value.
Either both should be same or target db compatible can be higher than the source compatible.
To fix it, While taking export use VERSION=11.2 parameter .
1 | $ expdp dumpfile=ABUZER.dmp logfile=ABUZER.log directory=EXPDIR full=y version=11.2 |
