Re: Multiple Tablespaces

From: Dan Souza <dan_souza_at_hotmail.com>
Date: 30 Jan 2002 02:01:20 -0800
Message-ID: <a4162129.0201300201.32334c73@posting.google.com>

> Most datawarehouses I've worked on all have more than 100 tablespaces ...
> example - large tables containing historical data : 12 months - 12
> partitions -

I forgot to mention:

-we dont use partitioning
-no historical data is separated / archived, it all remains in the same tables.
-we use 1MB striping with VVM across 32 disk spindles.

Glad to see it makes as little sense to you guys as it does to us. Received on Wed Jan 30 2002 - 04:01:20 CST