Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating Primary Key

Ganesh SrivatsavMar 9 2010 — edited Mar 28 2011
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2011
Added on Mar 9 2010
19 comments
6,445 views