tablespace management in data warehouse

I'm looking for information on defining tablespaces for partitions in a data warehouse. For example if I'm partitioning a table by month what's the best way to predefine the tablespaces for each monthly partition. I'm considering defining each tablespace with a small datafile size and using autoextend to grow the datafile if required. Should I define all tablespaces for the next couple of years or should I define them dynamically i.e at load time??

Any information appreciated especially documents, articles or white papers.

I'm using Oracle 8i on Unix Solaris.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 01 2000 - 16:40:37 CST