首页 » 技术分享 » oracle impdp ORA-39002

oracle impdp ORA-39002

 

1. 导入报错

[oracle@testlink-standby ~]$ impdp system/oracle@orcl DIRECTORY=db_backup DUMPFILE=QA2_EXPORT.DMP LOGFILE=impdp_FALABELLA_SO_CO_STG_20120802.log  SCHEMAS=qa2_atgcatalogb_mf  CONTENT=ALL PARALLEL=1 TABLE_EXISTS_ACTION=REPLACE

Import: Release 11.2.0.1.0 - Production on Tue Jun 25 01:42:49 2013

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-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-31640: unable to open dump file "/opt/oracle/db_backup/QA2_EXPORT.DMP" for read
ORA-19505: failed to identify file "/opt/oracle/db_backup/QA2_EXPORT.DMP"
ORA-27046: file size is not a multiple of logical block size
Additional information: 1

[oracle@testlink-standby ~]$ 

2. Matelink上给出的原因:

To BottomTo Bottom

转载自原文链接, 如需删除请联系管理员。

原文链接:oracle impdp ORA-39002,转载请注明来源!

0