使用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
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博客 ” ，链接：https://blog.itpub.net/30373263/viewspace-2101094/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
