Re: rollback schema changes

From: Noons <>
Date: Sun, 27 Mar 2011 15:19:41 +1100
Message-ID: <immdql$knp$>

prunoki wrote,on my timestamp of 27/03/2011 6:25 AM:

> Is there a way to rollback schema changes, other than restoring from
> backup until a specific time or SCN? The database in question is 10g.
> I mean without writing a complete script to undo the changes of
> course.
> The goal would be to undo the effects of a faulty script which
> generates an error midway, but has made several alter tables and such.
> If I want to run the full, corrected script again, it would be nice
> not to spend a day performing a restore.

Other than a flashback database - which (assuming you have lots of free disk space) does the lot, not just selected ones - I know of no other way than good old export/imp. Or a recovery from backup. One thing I do is to have our DR system ready to go. If a table or two are lost from production or test by an errant script, I can always wind up the DR system and copy/exp-imp the missing tables from there. Received on Sat Mar 26 2011 - 23:19:41 CDT

Original text of this message