ORA-39358: Export Dump File Version Not Compatible

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 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.2
Now try to import, It will succeed.