dumb question: back out plan for rebuilding indexes...
I know this is going to sound like a dumb question, and perhaps I should consider changing my alias to dumb-dba but I think that name is already taken.... Ha, ha... :-)
I'm at a site that has very strict change management rules, and even running a job to rebuild indexes requires a Change Request, and a backout plan.
I'm running Oracle 11g EE (not that it matters).
Any idea what to put down for "Backout Plan"?
As far as I know, the only backout would be to enter Ctrl-C while rebuilding the index and Oracle would automatically revert back to using the original index.
Or, if something crazy happened and the index hit corrupt blocks or something, just rebuild it again.
Any other ideas?