Hi,
This is a performance issue rather than a religious issue.
Not only should you be using separate tablespaces, but their files
should be on different disk drives. The purpose is to minimize disk
head movement when seeking data.
Since Gert already answered your main question I won't ;-)
regards
Jerry Gitomer
khinkle_at_indcompsrc.com wrote in message <7h7c7b$fmb$1_at_nnrp1.deja.com>...
>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 Tue May 11 1999 - 08:20:46 CDT