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上给出的原因:
相关推荐