Re: primary key indexes - where ???

From: Ken Taylor <taylorkh_at_nando.net>
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

Original text of this message