Re: rollback schema changes

From: mhoys <>
Date: Mon, 28 Mar 2011 08:31:45 -0700 (PDT)
Message-ID: <>

On Mar 26, 9:25 pm, prunoki <> wrote:
> Hello,
> 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.
> Regards,
> Krisztian

If the script drops objects, you could try the recycle bin.

Matthias Received on Mon Mar 28 2011 - 10:31:45 CDT

Original text of this message