RE: Database Outages - Best Practices
- From: david wendelken <davewendelken@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 17 Feb 2005 06:30:06 -0800 (PST)
>> 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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
