Achive Zero Downtime for routine table partition purging
DB: Oracle 11.2.0.3
OS: Linux
Hello Team,
We are performing a routing table partiton purging of historic partition and we used to bring down the application to achive this process.
Erlier we used to perform below tasks for purging data older than 1 year.
1) stop application
2) disable constrains on the table which we want to perform maintenece. (alter table X disable constrain XXX )
3) drop partition (interval partitoned table) older than 1 year.- stmt used (alter table X drop partiton Y.)
4) rebuild global indexes.
5) enable constrains.(alter table X enable novalidate constrain XXX )
6) start application.
To achive zero downtime for doing routine table maintenece we planning to use below steps.