Impdp experience ORA-39001, ORA-39000, ORA-39142

Impdp experience ORA-39001, ORA-39000, ORA-39142
Expdp/impdp because the source data version is higher than the target database version, encounter ORA-39001, ORA-39000, ORA-39142, solve only need to expdp export with the target data version, the specific problem and solution is as follows:

Import error:

[oracle@orcle02 ~]$ impdp scott/tiger directory=expdp dumpfile=wxlun1212.dmp logfile=wxlun1212.log remap_schema=wxlun:scott REMAP_TABLESPACE=wxlun:USERSImport: Release 10.2.0.4.0 - 64bit Production on Friday, 12 December, 2014 8:06:09Copyright (c) 2003, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-39001: invalid argument valueORA-39000: bad dump file specificationORA-39142: incompatible version number 3.1 in dump file "/home/oracle/wxlun1212.dmp"

Target database version:

[oracle@orcle02 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 12 08:07:11 2014Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64biPL/SQL Release 10.2.0.4.0 - ProductionCORE 10.2.0.4.0 ProductionTNS for Linux: Version 10.2.0.4.0 - ProductionNLSRTL Version 10.2.0.4.0 - ProductionSQL>

Source database version:

[oracle@orcle01 expdp]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 11 20:05:46 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning and Data Mining optionsSQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE 11.2.0.4.0 ProductionTNS for Linux: Version 11.2.0.4.0 - ProductionNLSRTL Version 11.2.0.4.0 - ProductionSQL> exit

The source database version is 11.2.0.4.0 and the target database version is 10.2.0.4.0. The source database version is later than the target database version. When the source database exports data, add the target version:

[oracle@orcle01 expdp]$ expdp wxlun/wxlun123 tables=wxlun.WXLUN_TAB01,wxlun.WXLUN_TAB02 directory=expdp dumpfile=wxlun1212.dmp logfile=wxlun1212.log version=10.2.0.4.0Export: Release 11.2.0.4.0 - Production on Fri Dec 12 08:08:56 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning and Data Mining optionsStarting "wxlun"."SYS_EXPORT_TABLE_01": wxlun/******** tables=wxlun.WXLUN_TAB01,wxlun.WXLUN_TAB02 directory=expdp dumpfile=wxlun1212.dmp logfile=wxlun1212.log version=10.2.0.4.0Estimate in progress using BLOCKS method...Processing object type TABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 45 MBProcessing object type TABLE_EXPORT/TABLE/TABLEProcessing object type TABLE_EXPORT/TABLE/COMMENTProcessing object type TABLE_EXPORT/TABLE/INDEX/INDEXProcessing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . exported "wxlun"."WXLUN_TAB01" 19.41 MB 169682 rows. . exported "wxlun"."WXLUN_TAB02" 18.43 MB 168011 rowsMaster table "wxlun"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded******************************************************************************Dump file set for wxlun.SYS_EXPORT_TABLE_01 is:/u01/app/oracle/expdp/wxlun1212.dmpJob "wxlun"."SYS_EXPORT_TABLE_01" successfully completed at Fri Dec 12 08:09:02 2014 elapsed 0 00:00:05

Import again. Successful:

[oracle@orcle02 ~]$ impdp scott/tiger directory=expdp dumpfile=wxlun1212.dmp logfile=wxlun1212.log remap_schema=wxlun:scott REMAP_TABLESPACE=wxlun:USERSImport: Release 10.2.0.4.0 - 64bit Production on Friday, 12 December, 2014 8:09:36Copyright (c) 2003, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsMaster table "SCOTT"."SYS_IMPORT_FULL_01" successfully loaded/unloadedStarting "SCOTT"."SYS_IMPORT_FULL_01": scott/******** directory=expdp dumpfile=wxlun1212.dmp logfile=wxlun1212.log remap_schema=wxlun:scott REMAP_TABLESPACE=wxlun:USERSProcessing object type TABLE_EXPORT/TABLE/TABLEProcessing object type TABLE_EXPORT/TABLE/TABLE_DATA. . imported "SCOTT"."WXLUN_TAB01" 19.41 MB 169682 rows. . imported "SCOTT"."WXLUN_TAB02" 18.43 MB 168011 rowsProcessing object type TABLE_EXPORT/TABLE/COMMENTProcessing object type TABLE_EXPORT/TABLE/INDEX/INDEXProcessing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSJob "SCOTT"."SYS_IMPORT_FULL_01" successfully completed at 08:10:54[oracle@orcle02 ~]$