ORA-39142: incompatible version number in dmp file

I am getting th ORA-39142 error while using an export (expdp) from 10.2.0.4.to import into an 11.2.0.6 database:

 

Why does the import (impdp) give me this ORA-39142 error and how to I overcome the ORA-39142 error?

Export Scripts :

expdp \”/ as sysdba\” DIRECTORY= DATA_PUMP_DIR DUMPFILE=expdp_full_%u.dmp LOGFILE=expdp_full.log FULL=Y  parallel=8

Error Messages :

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-39142: incompatible version number 2.1 in dump file “/u01/exports/cust.dmp”

Solutions :

Source  Database :

oracle@p1dhsdb:~/scripts] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 – Production on Fri Dec 22 20:28:48 2017

Copyright (c) 1982, 2005, Oracle. All rights reserved.

 

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select version from v$instance;

VERSION
—————–
10.2.0.1.0

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@p1dhsdb:~/scripts] $cat impKDTAH.sh
impdp userid=\”/ as sysdba\” full=y DIRECTORY=EXP_DIR DUMPFILE=exp_kdtah_full.dmp logfile=ktah_ex.log
[oracle@p1dhsdb:~/scripts] $

Target Database :

[oracle@uatdhsdb:~] $sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 – Production on Fri Dec 22 20:28:03 2017

Copyright (c) 1982, 2008, Oracle. All rights reserved.

 

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
select version from v$instance
SQL> 2
SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
————— —————-
HOST_NAME
—————————————————————-
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
—————– ——— ———— — ———- ——- —————
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
———- — —————– —————— ——— —
1 kdtah
uatdhsdb
11.1.0.7.0 15-DEC-17 OPEN NO 1 STOPPED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

 

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@uatdhsdb:~] $cd scripts/
[oracle@uatdhsdb:~/scripts] $ls
expKDTAH.sh nohup.out

Source database export scripts

[oracle@uatdhsdb:~/scripts] $cat expKDTAH.sh
expdp userid=\”/ as sysdba\” full=y DIRECTORY= EXPIMP DUMPFILE=exp_kdtah_full.dmp LOGFILE=exp_kdtah_full.log version=10.2
[oracle@uatdhsdb:~/scripts] $

Target Database Import Scripts :

oracle@p1dhsdb:~/scripts] $cat impKDTAH.sh
expdp userid=\”/ as sysdba\” full=y DIRECTORY= EXPIMP DUMPFILE=exp_kdtah_full.dmp LOGFILE=imp_kdtah_full.log

 

 

Hits: 5

Leave a Reply

Your email address will not be published. Required fields are marked *