While importing a dump into our 11g database, we got the below error.

 

impdp dumpfile=test1.dmp logfile=imp1.log directory=t

Import: Release 11.2.0.4.0 – Production on Mon Jan 23 08:57:03 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Username: / AS SYSDBA

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 4.1 in dump file “/dmdata07/test/test1.dmp”

 

CAUSE:

The export dump is from oracle 12c database. So while importing the dump into lower version db, it is throwing incompatible version error.

Lets check the header information of the dump. For this we need to create one package . Download show_dumpfile_info

exec sys.show_dumpfile_info(‘T’,’test1.dmp’);

Header information shows the the dump version is of release 12c.

SOLUTION:

So to import a dump from higher version(12c) to lower version(11g) , we need to use VERSION=11.2 parameter while taking export( in higher version)

1. Connect to 12c db and take export with version parameter

2. Now login to 11g and check the dump version from header

We can see the now the version is showing as 11gR2 . Now try to import the dump in 11g db, it will work

Similarly , for expdp impdp from 11g to 10g, need to use VERSION=10.2

 

HAVE A LOOK –   COLLECTION OF USEFUL DATABASE SCRIPTS

 

SEE NEW FEATURES OF ORACLE 12.2