Re: rollback schema changes
From: mhoys <matthias.hoys_at_gmail.com>
Date: Mon, 28 Mar 2011 08:31:45 -0700 (PDT)
Message-ID: <122f8476-784b-4965-af9a-83a4a4d88dd4_at_z20g2000yqe.googlegroups.com>
On Mar 26, 9:25 pm, prunoki <hegyv..._at_ardents.hu> 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
Date: Mon, 28 Mar 2011 08:31:45 -0700 (PDT)
Message-ID: <122f8476-784b-4965-af9a-83a4a4d88dd4_at_z20g2000yqe.googlegroups.com>
On Mar 26, 9:25 pm, prunoki <hegyv..._at_ardents.hu> 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