[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博客 ” ,链接:http://blog.itpub.net/30373263/viewspace-2101094/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30373263/viewspace-2101094/