ORA-39358: Export dump file version 18.3.0.0.0 not compatible with target version 18.1.0.0.0

Hi,

Sometimes You can get ” ORA-39358: Export dump file version 18.3.0.0.0 not compatible with target version 18.1.0.0.0 ” during impdp operation.

 

Details of error are as follows.

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39358: Export dump file version 18.3.0.0.0 not compatible with target version 18.1.0.0.0

 

 

Target database compatibility can not be lower than source database compatibility. If Target database compatibility is lower than source database compatibility, then you should use the version parameter and run export with version of target database compatibility.

 

Check Source ( export ) compatibility as follows.

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 18.3.0.0.0
noncdb_compatible boolean FALSE
SQL>

 

and Check Target ( import ) compatibility as follows.

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 18.0.0
noncdb_compatible boolean FALSE
SQL>

 

To solve this error, you may modify target compatibility from 18.0.0 to 18.3.0 as follows.

SQL> alter system set compatible='18.3.0' scope=spfile;

System altered.

SQL>

 

And restart database then try to run same import command again.

 

Or You can use the version parameter in the export.

 

version=18.0

 

You can change this version value according to your database version.

 

Target database compatibility can not be lower than source database compatibility. If Target database compatibility is lower than source database compatibility, then you should use the version parameter and run export with version of target database compatibility.

 

To solve this error, run the export again using the version parameter as follows.

 expdp \"/ as sysdba\" directory=PUMP schemas=MSD dumpfile=MSD_NEW%U.dmp version=18.0 logfile=MSD_NEW.log parallel=32 cluster=n exclude=statistics

 

Once export is completed, you can run the import in the source, it will work fine.

Do you want to learn more details about Oracle Datapump, then read the following articles.

https://ittutorial.org/oracle-data-pump-export-import-4/