Re: reclaiming table size

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 15 Jun 1999 10:37:07 -0400
Message-ID: <7k84p3$832$3@autumn.news.rcn.net>

Hi,

If it doesn't take too long to copy a table you might consider the following:

Lock the original table
CREATE new_table AS SELECT * FROM original_table.
DROP original table
Rename the new table
Recreate any indexes, constraints, etc.

Ideally this should be run after normal business hours as a cron job.

regards

Jerry Gitomer

eoin7_at_my-deja.com wrote in message <7k3r99$3sa$1_at_nnrp1.deja.com>...
>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 - 09:37:07 CDT