Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> enabling primary key

enabling primary key

From: Phillip <tienp_at_wholefoods.com>
Date: Tue, 20 Mar 2001 17:46:50 GMT
Message-ID: <3AB7986F.A7F171B4@wholefoods.com>

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.

--
Phillip
Received on Tue Mar 20 2001 - 11:46:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US