Please click on the INDEX and browse for more interesting posts.

Recently while I was trying to import a Dump file from Production to Non Prod, I received the below error: 

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


This means that the compatible parameter set in Non Production Database is lower to that of Production database, which is the reason for the error.

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.

You can check the compatible parameters in both your environments with the below command

show parameter compatible

So, to overcome the error, you need to take a fresh Export appending the below parameter highlighted in bold

expdp \'/ as sysdba\'  dumpfile=infra.dmp logfile=infra.log directory=EXPDIR full=y version=