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

Jackie:

Use "ALTER TABLE tablename ADD CONSTRAINT tablename_pk PRIMARY KEY (columnname) USING INDEX TABLESPACE tablespacename".

If the PK indexes have already been created, then you can simply use "ALTER INDEX tablename_pk REBUILD TABLESPACE newtablespacename" to rebuild the index on a different ts. It actually does this (in 7.3) without dropping the PK or any FK's that reference the PK.

Good luck,
Dave Sisk

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 Sat Feb 21 1998 - 00:00:00 CST