Re: reclaiming table size

From: Chris Colclough <chris.colclough_at_jhuapl.edu.nospam>
Date: Tue, 15 Jun 1999 08:10:49 -0400
Message-ID: <376642C8.E24DCFA3@jhuapl.edu.nospam>

Adjust pctfree and pctused so that Oracle will make the greatest use of space available within a table.

hth
cc

eoin7_at_my-deja.com wrote:

> Oracle 8:
>
> I have some tables that store data temporarily, with many inserts and
> deletes occuring daily. The tables can never be empty, so TRUNCATE is
> not an option.
>
> What is the best way to manage the table size?
> Will these tables continue to use more and more storage in the
> tablespace because of not being able to TRUNCATE REUSE STORAGE?
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jun 15 1999 - 07:10:49 CDT