Xref: alice comp.databases.oracle.server:83005
Message-ID: <3897E9DD.86B264BE@totalise.co.uk>
Date: Wed, 02 Feb 2000 08:25:01 +0000
From: Martin Hepworth <maxsec@totalise.co.uk>
X-Mailer: Mozilla 4.7 [en-gb] (WinNT; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
To: jeremycdba@my-deja.com
Subject: Re: tablespace management in data warehouse
References: <877nd4$75g$1@nnrp1.deja.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: 2 Feb 2000 08:25:47 GMT, bisgw.blackwell.co.uk
Lines: 26
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newspeer.clara.net!news.clara.net!newspeer.highwayone.net!news2lo.highwayone.net!bisgw.blackwell.co.uk

jeremycdba@my-deja.com wrote:
> 
> 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.

Jeremy

Theres a rather useful book written by a couple of Oracle employees
(Lilian Hobbs and Susan Hillson) called "Oracle 8i Data Warehousing"
ISBN 1555582052 that goes through all these issues. Also Ralf Kimballs
books talk about these issues from a general RDBMS point.

Martin