Most times we are in a situation to rollback the database to a good known state before starting our tests (LQ/BQ/Whatever Tests). An old article directly from Oracle suggests the following method: To quote from the same: Restore Points Jane proceeds to demonstrate how to use restore points, starting with an example of how Paul's QA team can benefit from this technique. Jane creates a restore point named qa_gold. create restore point qa_gold; This command, Jane reminds them, is new in Oracle Database 10 g Release 2. It creates a named restore point, which is an alias to the system change number (SCN) of the database at that time. Jane runs one of the QA team's tests, altering the test data. To flash back the database to the restore point she created, Jane shuts down the database, restarts it in mounted mode, and issues the flashback database command. shutdown immediate; startup mount; flashback database to restore point qa_gold; That's it; the database is now "r...