Hi, I did a datapump export from 10g. everything is fine in a dumpfile but when i tried to import it in 11g, I got the following error
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 "PLLDBA"."ACTL_PK" ON "PLLDBA"."ACTL" ("LOTID") 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 "PLL_DEFAULT_IDX_TBS" PARALLEL 1
Completed 334 INDEX objects in 30963 seconds
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-02437: cannot validate (PLLDBA.ACTL_PK) - primary key violated
Failing sql is:
ALTER TABLE "PLLDBA"."ACTL" ADD CONSTRAINT "ACTL_PK" PRIMARY KEY ("LOTID") 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) TABLESPACE
I checked the source db (10g) and i did not found any duplicate values. What could be the cause of this problem?