RE: Database Outages - Best Practices

>> Table reorgs (Typically after huge deletes as in a table purge..)

>> ...So you purge data, drop a table from 27G to 16G , ...

Aren't huge deletes like this forseeable when the system is built?

If so, couldn't the tables be partitioned according to the criteria for deletion - such as accounting period, etc.?

I know - not always!

But where it could be, the downtime wouldn't be needed at all, would it?

Just drop the partition and be done with it. Or have I misunderstood how partitions work?

--
http://www.freelists.org/webpage/oracle-l