Oracle impdp全库导入报错总结

impdp全库导入报错总结

问题表述：impdp全库导入时，会遇到大量报错，有些报错可以忽略，有些报错需要处理，做个总结。

操作系统：aix–>linux

数据库版本：11.1.0.7–>11.2.0.4

操作：impdp

参考文档：详见各具体报错

详细报错及处理过程：

报错1： Cannot set an SCN larger than the current SCN

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
>>> Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropped and recreated. See My Oracle Support article number 1380295.1.

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM

解决：

添加参数STREAMS_CONFIGURATION=N

---

报错2：ORA-39083 ORA-01031

ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_DOCS_TMP" failed to create with error:
ORA-01031: insufficient privileges

Failing sql is:
CREATE GLOBAL TEMPORARY TABLE "ORDDATA"."ORDDCM_DOCS_TMP" ("DOC_ID" NUMBER(*,0) NOT NULL ENABLE, "DOC_NAME" VARCHAR2(100 CHAR) NOT NULL ENABLE, "DOC_TYPE_ID" NUMBER NOT NULL ENABLE, "DOC_CONTENT" "SYS"."XMLTYPE"  NOT NULL ENABLE, "ORACLE_INSTALL" NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, "CREATE_DATE" DATE DEFAULT SYSDATE NOT NULL ENABLE) ON COMMIT PRESERVE ROWS

解决：

忽略，也可以手动执行失败的sql，可以执行成功。

参考：ORA-39083/ORA-1031 While Importing An ORDDATA Table (Doc ID 1909772.1)

---

报错3：ORA-39083 ORA-23327

ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db

解决：

源库和目标库的global_name不一致。导入的时候，重新设置global_name，导入完成后，再改回去。或者可以忽略。

参考：IMPDP - ORA-23327 (does Not Match GLOBAL NAME) On PRE_TABLE_ACTION (Doc ID 1568721.1)

---

报错4：ORA-39117 ORA-390