Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: reclaiming table size
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