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@orcl...
impdp username/password directory=data_pump_dir dumpfile=*.dmp full=y ora-39001: 参数值无效 ora-3900: 转储文件说明错误 ora-39142: 版本号3.1(...)不兼容 是因为从高版本到低版本,不兼容导至的。 只需要在源端 11.2上面加上版本号导出即可 expdp username/password directory=data_pump_dir dumpfile=*...
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,源端...
ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39142: incompatible version number 3.1 in dump file "/u01/app/oracle/expdp/G.dmp" 解决办法: 重新导出加上参数version [oracle@oracle-test ~]$expdp oracle/oracle directory=impdir dumpfile=G01.dmp Version=10.2.0.4.0 E...
Advanced Analytics and Real Application Testing options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39142: incompatible version number 4.2 in dump file "/DB_BKP/atmauprd/maut8_ib_owner.dmp" oracle@s01zclient10...
expdp/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 ...