oracle导出39001,impdp遭遇ORA-39001、ORA-39000，ORA-39142

xpdp/impdp由于源数据版本高于目标数据库版本，遭遇ORA-39001、ORA-39000，ORA-39142，解决只需要expdp导出时加上目标数据的version，具体问题及解决如下：

导入报错：

[oracle@orcle02 ~]$ impdp  scott/tiger  directory=expdp  dumpfile=wxlun1212.dmp logfile=wxlun1212.log remap_schema=wxlun:scott  REMAP_TABLESPACE=wxlun:USERS

Import: Release 10.2.0.4.0 - 64bit Production on Friday, 12 December, 2014 8:06:09

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.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 3.1 in dump file "/home/oracle/wxlun1212.dmp"

目标端数据库版本：

[oracle@orcle02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 12 08:07:11 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE    10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

源端数据库版本：

[oracle@orcle01 expdp]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 11 20:05:46 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning and Data Mining options

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

SQL> exit

源端数据库版本11.2.0.4.0,目标端数据库版本10.2.0.4.0，源端数据库版本高于目标端数据库版本，源端导出数据时加上目标端version：

[oracle@orcle01 expdp]$ expdp  wxlun/wxlun123 tables=wxlun.WXLUN_TAB01,wxlun.WXLUN_TAB02 directory=expdp dumpfile=wxlun1212.dmp logfile=wxlun1212.logversion=10.2.0.4.0

Export: Release 11.2.0.4.0 - Production on Fri Dec 12 08:08:56 2014

Copyright (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 Production

With the Partitioning and Data Mining options

Starting "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.0

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 45 MB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/COMMENT

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing 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 rows

Master table "wxlun"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for wxlun.SYS_EXPORT_TABLE_01 is:

/u01/app/oracle/expdp/wxlun1212.dmp

Job "wxlun"."SYS_EXPORT_TABLE_01" successfully completed at Fri Dec 12 08:09:02 2014 elapsed 0 00:00:05

再次导入，成功：

[oracle@orcle02 ~]$ impdp  scott/tiger  directory=expdp  dumpfile=wxlun1212.dmp logfile=wxlun1212.log remap_schema=wxlun:scott  REMAP_TABLESPACE=wxlun:USERS

Import: Release 10.2.0.4.0 - 64bit Production on Friday, 12 December, 2014 8:09:36

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "SCOTT"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SCOTT"."SYS_IMPORT_FULL_01":  scott/******** directory=expdp dumpfile=wxlun1212.dmp logfile=wxlun1212.log remap_schema=wxlun:scott REMAP_TABLESPACE=wxlun:USERS

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "SCOTT"."WXLUN_TAB01"                       19.41 MB  169682 rows

. . imported "SCOTT"."WXLUN_TAB02"            18.43 MB  168011 rows

Processing object type TABLE_EXPORT/TABLE/COMMENT

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "SCOTT"."SYS_IMPORT_FULL_01" successfully completed at 08:10:54

impdp hstms/hstms remap_schema=tms:zhdz directory=imp_dir dumpfile=TBL_APOS_INFO.dat version=10.2.0.4.0 TRANSFORM=segment_attributes:n TABLE_EXISTS_ACTION=replace