- 20 Dec, 2023
- 0 Comments
- 1 Min Read
ORA-39358: Export Dump File Version Not Compatible
Solution :
1. Check the compatible parameter of both source and target database.
@SOURCE DataBase:
SQL>> show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ---------------------------- compatible string 12.1.0.2.0 noncdb_compatible boolean FALSE@TARGET DataBase:
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.1.0.2) 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 database compatible can be higher than the source compatible.
To fix it, While taking export use VERSION=11.2 parameter .
expdp dumpfile=test.dmp logfile=test.log directory=EXPDIR full=y version=11.2Now try to import, It will succeed.