Not sure how "easy" it is - but have a look at using Editions in 11gr2 Stefan ========================= Stefan P Knecht CEO & Founder s@xxxxxxxx 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 Wallisellen Switzerland Phone +41-(0)8400-10046 Cell +41 (0) 79 571 36 27 info@xxxxxxxx http://www.10046.ch ========================= On Wed, Aug 10, 2011 at 11:52 PM, Michael Dinh <mdinh@xxxxxxxxx> 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.**** >