I am trying to create primary key on a table, which is large - 18GB
ALTER TABLE "DCS2000"."TBL_WIP_HIST_ERROR" ADD CONSTRAINT "PK_WIP_HIST_ERROR" PRIMARY KEY ("PARENT_ID","CLAIM_NO", "WIP_ERROR_KEY")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 209715200 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "PRODIX" ENABLE
It is taking for ever. I have gathered statistics on the table, but still no luck.
Is there any way to get this done faster?
Regards,
G.