Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> enabling primary key
Let's say I used this statement to create a primary key on a table:
ALTER TABLE "SLSPH1EE" ADD CONSTRAINT "SLSPH1EEP1" PRIMARY KEY
("SLS_ORG_CHILD","SLS_PRD_CHILD","SL
S_DET_NUM","SLS_YEAR","SLS_PERIOD","SLS_WEEK","SLS_DAY") USING INDEX
PCTFREE 10 INITRANS 2 MAXTRANS
255 STORAGE (INITIAL 314572800 NEXT 314572800 MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREEL
ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
"SLSPH1INDXP_NU" ENABLE NOVALIDATE
Then I disabled the primary key using the "alter table SLSPH1EE disable
primary key;" command. If I want to re-enable the primary key, does it
essentially run this statement again? In other words, does "alter table
SLSPH1EE enable primary key;" execute the above statement?
What are some ways to improve the performance of re-enabling the primary key? Please copy all responses to tienp_at_wholefoods.com. Thanks.
-- PhillipReceived on Tue Mar 20 2001 - 11:46:50 CST
![]() |
![]() |