Hi Tom - I work in Java, and we run a large number of Java testcases every night one after another. All the tests execute against the same schema, and in order to make sure the initial data is known, each test drops and recreates all the objects in the schema and repopulates the default data. We're also using an ORM to generate many of the DDL commands for us. Our schema contains about 150 tables with no more than a few hundred rows in each table. It takes about 30 minutes to get the schema and test data setup. Most of our testcases execute within a few seconds if the aside from the schema preparation, so I'm looking for a way to speed this up, as it limits how many tests we're able to run each night.

I am wondering if there is a common way of quickly reverting a schema to a known state. Many of the testcases use multiple transactions so we can't simple rollback. I've tried using exp/imp but I'm wondering if there is better option I'm missing. My understanding of flashback is that it affects the entire DB and not just a single schema, in which case it would not be an option for me. Thanks for any suggestions.