Re: index made with constaint resides in table's tablespace...

From: A.E.Vervaeke <alanv_at_opustel.com>
Date: 1998/02/19
Message-ID: <6chp1m$kq3@news9.noc.netcom.net>#1/1

Try this as an example:

CREATE TABLE salgrade (

grade            NUMBER(12)      CONSTRAINT salgrade_pk PRIMARY KEY
                                                     USING INDEX TABLESPACE
sys_tools_d
                                                     storage (initial 8k
next 8k pctincrease 0 maxextents 100),
losal              NUMBER(12),
hisal              NUMBER(12),

empname VARCHAR2(24))
TABLESPACE sys_users_d
STORAGE (INITIAL 40k NEXT 8k MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 5)  /
I hope this helps.
Alan V.

Jackie A. Marino wrote in message <34EB2E25.4E92_at_tgpl.twc.com>...
>Hello,
>
>When I make a constraint (ie, primary key) on a table or column in a
>table, the index is made and stored in that table's tablespace. How can
>I get that index to be made in another tablespace?
>
>I use 'create index tablespace user_index', when I create an index aside
>from the table, but the constraints that need to be with the table have
>to be in the table's tablespace, right? Is there a way to move the
>index or specify where it goes in the create table syntax?
>
>Thanks,
>
>Jackie Marino
>WGP-Transco
>Houston, TX
Received on Thu Feb 19 1998 - 00:00:00 CST