Restore points? http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_6011.htm 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.**** > -- Toon Koppelaars RuleGen BV Toon.Koppelaars@xxxxxxxxxxx www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.rulegen.com/am4dp-backcover-text