impdp error

Posted by Arsala on Oct 26, 2016; 9:25am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/impdp-error-tp1444.html


Sir

I want to export schema it exported without  errore

expdp system/XXXXXX schemas=SIGTASAD directory=backup dumpfile=SIG.dmp logfile expdpsh.log;


when I import it give error  like below

impdp system/XXXXXX schemas=SIGTASAD directory=backup dumpfile=SIG.dmp logfile impdpsh.log;

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Failing sql is:
CREATE UNIQUE INDEX "SIGTASAD"."CORP_REG_NAME_FK_I" ON "SIGTASAD"."CORPORATION" ("REGIST_NAME") PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IRD_INDEXES" PARALLEL 1
ORA-39083: Object type INDEX failed to create with error:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Failing sql is:
CREATE UNIQUE INDEX "SIGTASAD"."ESTAB2_UK" ON "SIGTASAD"."ESTABLISHMENT" ("ENTERPRISE_NO", "CITY_NO", "NAME", "ADDRESS", "STREET_NO", "PARCEL_NO") PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE
ORA-39083: Object type INDEX failed to create with error:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Failing sql is:
CREATE UNIQUE INDEX "SIGTASAD"."IND_TZ_REG_UK" ON "SIGTASAD"."INDIVIDUAL" ("NAT_CARD_ID", "TZ_REG_BOOK", "TZ_REG_PAGE") PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "IRD_INDEXES" PARALLEL 1
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-02299: cannot validate (SIGTASAD.IND_TZ_REG_UK) - duplicate keys found
Failing sql is:
ALTER TABLE "SIGTASAD"."INDIVIDUAL" ADD CONSTRAINT "IND_TZ_REG_UK" UNIQUE ("NAT_CARD_ID", "TZ_REG_BOOK", "TZ_REG_PAGE") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPA
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-02299: cannot validate (SIGTASAD.ESTAB2_UK) - duplicate keys found
Failing sql is:
ALTER TABLE "SIGTASAD"."ESTABLISHMENT" ADD CONSTRAINT "ESTAB2_UK" UNIQUE ("ENTERPRISE_NO", "CITY_NO", "NAME", "ADDRESS", "STREET_NO", "PARCEL_NO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255  STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLAS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"SIGTASAD"."IND_TZ_REG_UK" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"SIGTASAD"."ESTAB2_UK" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"SIGTASAD"."CORP_REG_NAME_FK_I" creation failed