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

From: David Vanidour <dvanidou_at_psc-cfp.gc.ca>
Date: 1998/02/19
Message-ID: <34ECBFF9.4A85@psc-cfp.gc.ca>#1/1

My Oracle7(tm) Server SQL Language Referance Manual gives the following example. (PAGE 4-213)

CREATE TABLE salgrade
  (grade NUMBER CONSTRAINT pk_salgrade

                   PRIMARY KEY
                   USING INDEX TABLESPACE users_a,

   losal NUMBER,
   hisal NUMBER )
  TABLESPACE human_resource
  STORAGE (INITIAL 6144 NEXT 6144

           MINEXTENTS 1 MAXEXTENTS 5
           PCTINCREASE 5);

According to the documentation on the CONSTRAINT clause (PAGE 4-121, same manual) you can specify storage for the index as well.

Cheers.

Jackie A. Marino wrote:
>
> 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