Xref: alice comp.databases.oracle.server:39530
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-ge.switch.ch!serra.unipi.it!news.esrin.esa.it!not-for-mail
From: James Dickson <James.Dickson@mail.esrin.esa.it>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to save disk space in Oracle 7 database?
Date: Tue, 02 Feb 1999 10:42:09 +0100
Organization: European Space Agency / Serco
Lines: 28
Message-ID: <36B6C871.2CD@mail.esrin.esa.it>
References: <36aba9bb.83542582@news.u.washington.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)

Calamba Lee wrote:
> 
> Hi All!
> 
> I am a novice Oracle DBA and would greatly appreciate your help:
> 
> We have a DataWarehouse type Oracle 7 database (read only) which we
> load with data (append) monthly on the Unix box.
> 
> It turns out that we do not have enough physical disk space for the
> next load of data.
> 
> Other then adding more disks what options do I have to utilize
> existing disk space more efficiently? Can I tweak tablespace specs?
> How? Is there a sort of defrag or compress utilities for Oracle/Unix
> environment?


In the longer term you might want to look into upgrading
to Oracle v8, then partition your tables by month. 

While you still run Oracle v7 you will eventually be forced
to export the oldest data to a tape in order to make space
for incoming new data.

James
-- 
james@valhall.esrin.esa.it.NOSPAM