Re: Where to store indexes for partitioned tables?

MrSmee wrote:

> Thank you for the prompt reply.
>
> I have to confess that I wasn't entirely sure of the purpose of putting
> the partition into individual tablespaces.

Then I will tell you ... one tablespace per partition. One doesn't, as groups_at_karsten-schmidt.com suggests "the poor dba that needs to create a new tablespace and drop an old one each month. then sizing. How do you size the new tablespace ?"

But it is the very poor DBA indeed that can't figure out that a tablespace consists of one or more datafiles and that at any time an additional datafile can be added and sized appropriately.

Based on your original post I would suggest one partition equals one tablespace as it will greatly ease maintenance and additional tablespaces will get you absolutely nothing of value.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)