---恢复前删除用户表空间和数据库drop user sy_escs cascade;

1.创建索引出错 

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-14102: only one LOGGING or NOLOGGING clause may be specified
Failing sql is:
CREATE UNIQUE INDEX "SY_ESCS"."PK_IM_EXT_JYMX" ON "SY_ESCS"."IM_EXT_JYMX" ("ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING NOCOMPRESS LOGGING TABLESPACE "SY_CS" PARALLEL 1
ORA-39083: Object type INDEX failed to create with error:
ORA-14102: only one LOGGING or NOLOGGING clause may be specified

2. 对象索引数据 数据创建失败

ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"SY_ESCS"."IM_EXT_JYMX_FKZHHM" creation failed
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-01403: no data found
ORA-01403: no data foun
Failing sql is:
DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; BEGIN  DELETE FROM "SYS"."IMPDP_STATS";   c(1) := 'IP';  DBMS_METADATA.GET_STAT_INDNAME('SHINEYUEYUN_ESCS','T_WA_WX_IP_TENCENT',c,1,i_o,i_n);   INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1

3. 主外键约束错误
ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02270: no matching unique or primary key for this column-list
Failing sql is:
ALTER TABLE "SY_ESCS"."IM_GZYTMXB" ADD CONSTRAINT "FK_IM_GZYTM_REFERENCE_IM_GZK" FOREIGN KEY ("GZID") REFERENCES "SHINEYUEYUN_ESCS"."IM_GZK" ("ID") ENABLE

4. Job "SY_ESCS"."SYS_IMPORT_FULL_01" completed with 958 error(s) at 13:55:42

-----

后更新存储：SQL> execute  dbms_stats.delete_schema_stats('sy_escs');