A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

ORA-39358: Export Dump File Version Not Compatible With Target Version 

1 min read
After upgrading a database from to, the following errors are reported executing a datapump import process:
Import: Release - Production 
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options
ORA-39002: invalid operation
ORA-39358: Export dump file version not compatible with target version
The issue is because the COMPATIBLE parameter for the 12c importing database is still (value before the upgrade).
It was confirmed based on the information provided:

1. Version of the exporting database 12c (, compatible 12c (
2. Version of the importing database 12c (, compatible 11g (
In this case, there are next two solutions:

Use the parameter VERSION during the export process. It need to be set equal to the COMPATIBLE parameter value in the target database where the import is going to be executed.
Execute the export using parameter version equal to

$ expdp <user>/<password> tables=<OWNER>.<TABLE NAME> version=

Then, execute the import process:

$ impdp <user>/<password> tables=<OWNER>.<TABLE NAME>

Using this option, the version of the dumpfile version will be matching the compatible parameter on target system (
- OR -

Set compatible to on target system:

sql> alter system set compatible='' scope=spfile;

sql> shutdown immediate;

sql> startup;

sql> show parameter compatible;

Hope it worked !! 🙂