Xref: alice comp.databases.oracle.server:22282
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!ix.netcom.com!news
From: mnatty@ix.netcom.com
Newsgroups: comp.databases.oracle.server
Subject: Re: how to free idle space
Date: Sat, 06 Jun 1998 15:26:25 -0400
Organization: Netcom
Lines: 23
Message-ID: <357997E1.485@ix.netcom.com>
References: <3579418D.49E321D5@cressoft.com.pk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-NETCOM-Date: Sat Jun 06 12:26:39 PM PDT 1998
X-Mailer: Mozilla 3.0C-NC320  (Win95; U)
To: Umar FArooq <umar.farooq@cressoft.com.pk>

Umar FArooq wrote:
> 
> hi!
> i would like to free some space from my Oracle database without loosing
> any data (so I cannot use the truncate command). Can anyone tell me what
> steps should I follow? Do i use the DEALLOCATE clause of the ALTER TABLE
> command? How does it function? What other ways r there which would
> enable me to free extraneous space.
> 
> Thx.
> 
> Umar
> umar.farooq@cressoft.com.pk
If you're looking to reduce the database size, try RESIZEing the
datafiles.
Within the database, DEALLOCATE clause is an option, wherein it
deallocates those extents that were allocated but unused thus far.
A more effective way to free up space would be to export the table with
compress=Y, and drop the table and import it.

Hope it helps!

Nat Malupillai