Re: Deleting Large Numbers of Rows w/o Filling up my redo logs

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 22 Dec 2008 11:14:03 +0000 (UTC)
Message-ID: <ginspr$ll0$2@solani.org>


On Sat, 20 Dec 2008 17:37:55 +0100, Michel Cadot wrote:

> Partition your log table per week and drop oldest partition each week.

What should he do with the global indexes, like PK? Keep rebuilding? Shut down the application while the PK is being rebuilt?

-- 
Mladen Gogala
http://mgogala.freehostia.com
Received on Mon Dec 22 2008 - 05:14:03 CST

Original text of this message