使用impdp导入数据报错：ORA-39001/39000/39142

[oracle@ora10g ~]$ impdp bank/bank directory=my_dir dumpfile=USERBANK.DMP logfile=imp.log remap_schema=userbank:bank remap_tablespace=tablespace_bank:bank

Import: Release 10.2.0.5.0 - 64bit Production on Monday, 16 May, 2016 19:36:05

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.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/expbk/USERBANK.DMP"


问题分析：数据泵从高版本库向低版本库导入数据时必须指定版本号，否则会出现上面的错误


解决：使用下面的命令重新导出数据
expdp userbank/userbank directory=dumpdir dumpfile=userbank.dmp logfile=userbank.log version=10.2.0.5.0

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30373263/viewspace-2101094/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30373263/viewspace-2101094/