Re: Deleting from tables

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 20 Dec 1998 04:35:33 GMT
Message-ID: <367e7a71.28824540@netnews.worldnet.att.net>

If you are using Oracle8, you could look into the partitioning option. You could partitition the table based on the week ending date. Then each week you could drop the oldest partition, and create a new one. Dropping a partition should be more or less as fast as truncating the table.

regards,

Jonathan

On Fri, 18 Dec 1998 17:20:11 +0000, Siva Prakash <sprakash_at_cellnet.com> wrote:

>We have tried writing PL/SQL committing for every 500 or 1000 records.
>It is time consuming. Given this case, what would be the most effective
>way to
>get rid of data older than 60 days. Effective in terms of time and less
>fracturing
>in the tablespace.
Received on Sat Dec 19 1998 - 22:35:33 CST