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

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 Wed Feb 18 1998 - 00:00:00 CST