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-39083 ORA-31000
ORA-39117: Type needed to create table is not