Database DataWarehousing (MOSC)

MOSC Banner

Achive Zero Downtime for routine table partition purging

edited Apr 2, 2015 2:37PM in Database DataWarehousing (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center