Manual Index Creation

I'm still pretty new to Oracle. I keep hearing that I should be creating my indexes in a separate tablespace. Is this a religious issue, and if so can I hear arguments for and against?

I can see how doing this might give me more flexibility for I/O tuning later on, if I wanted to move the datafile to another set of disks...is that the primary reason for doing this?

My main question relates to the indexes Oracle automatically creates when you specify a primary key or unique constraint. Is there a standard procedure for "replacing" the auto-generated index with a manually created one?

Is there any problem with the following:

1. Create table with primary key
2. Alter table disable primary key
3. Create index on the pk column in the different tablespace
4. Alter table enable primary key

Does disabling the primary key constraint drop the auto-generated index, or should that be another step?

Any gotchas I should watch out for?

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 10 1999 - 14:31:55 CDT