impdp报错，exp没有问题

ORA-39083: Object type INDEX_STATISTICS failed to create with error:

ORA-01403: no data found

ORA-01403: no data found

Failing sql is:

DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := ‘YYYY-MM-DD:HH24:MI:SS‘;  stmt varchar2(300) := ‘ 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) VALUES (‘‘I‘‘,6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,NULL,:14,:15,NULL,:16,:17)‘;BEGIN  DELETE

产生原因：

系统自命名索引缺失。

解决办法：

oracle@localhost ~]$ impdp \"/ as sysdba\" dumpfile=test.dmp remap_schema=test:mt exclude=index

[oracle@localhost ~]$ impdp \"/ as sysdba\" dumpfile=test.dmp remap_schema=test:mt include=index

检查语句：

select segment_name, segment_type from dba_segments where owner=‘MT‘;

impdp报错，exp没有问题

原文：https://www.cnblogs.com/youzirourou/p/12598078.html