Re: Deleting Large Numbers of Rows w/o Filling up my redo logs
Date: Mon, 22 Dec 2008 11:14:03 +0000 (UTC)
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.comReceived on Mon Dec 22 2008 - 05:14:03 CST