SOLVED

ORA-39358: Export Dump File Version Not Compatible

Asked by OracleDba••16 views•oracle

ORA-39358: Export Dump File Version Not Compatible

#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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.
OracleDba•

Post Your Solution