分类: Oracle

impdp导入报错ORA-39001: invalid argument value

oracle导入dmp文件报错:

impdp 'username/password' directory=DIR_DUMP_T1 table_exists_action=replace dumpfile=b30.dmp
Import: Release 11.2.0.1.0 - Production on Wed Jan 10 16:20:14 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.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-39088: file name cannot contain a path specification

低版本的导入数据库在读高版本数据库由expdp产生的文件的时候很可能会产生上述错误,
比如对于上述问题而言,只需要在源数据库执行expdp的时候加上version=10.2.0.2,
然后在目标数据库执行impdp的时候也加上version=10.2.0.2的就OK了。
解决方法就是本着一个"就低不就高"的原则,
源数据库的版本是 11g 11.2.0.4.0,导入的目标库是11.2.0.1.0,版本有点差异,带上版本号Version=11.2.0.1.0重新导出:

[oracle@pldb2 expdir_tmp]$ expdp 'username/password'@PD1 DIRECTORY=DIR_DUMP_01 DUMPFILE=b30.dmp tables=BIS_TRAFFIC_INTSUMMARY_HOUR Version=11.2.0.1.0                                      
Export: Release 11.2.0.4.0 - Production on Wed Jan 10 16:18:24 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "POWERDESK"."SYS_EXPORT_TABLE_01":  powerdesk/********@PD1 DIRECTORY=DIR_DUMP_01 DUMPFILE=b30.dmp tables=BIS_TRAFFIC_INTSUMMARY_HOUR Version=11.2.0.1.0 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 80 MB
>>> DBMS_AW_EXP: BIN$TAsGFYCiGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCkGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCmGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCoGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCqGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCsGqfgUwwD+woJNg==$0 not AW$
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
>>> DBMS_AW_EXP: BIN$TAsGFYCiGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCkGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCmGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCoGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCqGqfgUwwD+woJNg==$0 not AW$
>>> DBMS_AW_EXP: BIN$TAsGFYCsGqfgUwwD+woJNg==$0 not AW$
. . exported "POWERDESK"."BIS_TRAFFIC_INTSUMMARY_HOUR"   63.76 MB  715644 rows
Master table "POWERDESK"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for POWERDESK.SYS_EXPORT_TABLE_01 is:
  /oracle/expdir_tmp/b30.dmp
Job "POWERDESK"."SYS_EXPORT_TABLE_01" successfully completed at Wed Jan 10 16:18:28 2018 elapsed 0 00:00:03

重新导入ok

impdp 'username/password' directory=DIR_DUMP_T1 table_exists_action=replace dumpfile=b30.dmp Version=11.2.0.1.0 ;

相关文章

发表新评论