Re: primary key indexes - where ???
Date: 1996/09/24
Message-ID: <527ar6$p4e_at_castle.nando.net>#1/1
"Brian P. Mac Lean" <brian.maclean_at_teldta.com> wrote:
>seci_at_ludens.elte.hu wrote:
>>
>> hello,
>>
>> if i have a table with a primary key it is obvious that oracle will
>> create an index (of course a unique one) to maintain this constraint
>> (but if i look at user_indexes i cannot see this index).
>>
>> is it possible to define the name and the TABLESPACE and STORAGE of this
>> kind of indexes or not?
>>
>> TIA
>> peter
Here is another approach which works...USING INDEX
CREATE TABLE RPRESNP.TEMP_AUDIT_LOG (
EVN_ID VARCHAR2(10) not null, ACT_DATE DATE not null, ACT_USERID CHAR(8) null, BEFORE_SCOPE_ACTION CHAR(18) null, AFTER_SCOPE_ACTION CHAR(18) null, REASON CHAR(40) null, AUTHORIZED_BY CHAR(18) null, OUT_SYS_SCH_INIT VARCHAR2(3) null,
here is the primary key constraint
CONSTRAINT PK_TEMP_AUDIT_LOG Primary Key (EVN_ID,ACT_DATE)
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE PRESTIGE03 STORAGE (INITIAL 524288 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0) )
the index has been created in tablespace "PRESTIGE03" with the specified storage criteria above
below is the specification to place the table's data in tablespace "PRESTIGE02"
MAXTRANS 255 INITRANS 1 PCTFREE 10 PCTUSED 40 TABLESPACE PRESTIGE02 STORAGE (INITIAL 524288 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0)
;
Hope this helps,
Ken Received on Tue Sep 24 1996 - 00:00:00 CEST