impdp遭遇ORA-39001、ORA-39000,ORA-39142

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

导入报错:
[oracle@orcle02 ~]$ impdp  scott/tiger  directory=expdp  dumpfile=test.dmp logfile=test.log remap_schema=test:scott  REMAP_TABLESPACE=test:USERS

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"

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

[oracle@orcle01 expdp]$ expdp  test/test123  directory=expdp dumpfile=test.dmp logfile=test.log version=10.2.0.4.0

原文地址:https://www.cnblogs.com/shujuyr/p/14630737.html