Re: Rollback Schema Changes

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 12 Aug 2011 15:24:45 +0200
Message-ID: <CAP50yQ8KJpwmuZLSdW0acm7BK4Yik98TZNE=F+a9PfW_23jGUA_at_mail.gmail.com>

Not sure how "easy" it is - but have a look at using Editions in 11gr2

Stefan

---

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Wed, Aug 10, 2011 at 11:52 PM, Michael Dinh <mdinh_at_xifin.com> wrote:

> We have a requirement to automate or provide control to developers to
> rollback all schema changes.****
>
> ** **
>
> For example: starting from a base line - test A performed - rollback to
> baseline - test B performed - rollback to baseline - test C performed -
> rollback to baseline.****
>
> ** **
>
> There can be hundreds of tests and this needs to be easily managed and
> automated from the application.****
>
> ** **
>
> Would datapump and/or flashback database work for this type of regression
> testing?****
>
> ** **
>
> Thanks for your ideas.****
>
> ** **
>
> Michael Dinh****
>
> ****
>
> NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
> individual or entity to which it is addressed, and may contain information
> that is privileged, confidential and exempt from disclosure under applicable
> laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH
> INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING,
> AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI
> CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT
> NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS
> MESSAGE. If the reader of this email (and attachments) is not the intended
> recipient, you are hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited. Please notify the
> sender of the error and delete the e-mail you received. Thank you.****
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 12 2011 - 08:24:45 CDT