enable/disable constraint, rebuild index

Hi everyone,

I learn recently that when you disable the primary key and unique key constraint. The indexes associated with it are gone. When you enable the constraint, Oracle will build the index on the user's default tablespace instead the of the tablespace that you specific when you create the primary key/unique constraint.

How about rebuilding index? Is it going to the user default or the tablespace that index resign in? (I really hope that it is the second one... I always think that it will go to the tablespace which I create the index instead of the default tablespace! =<)

Thanks everyone!

Winnie Received on Mon Aug 24 1998 - 20:26:57 CDT