I would like to use Selenium to test a web application but in order to do that successfully the tests must be run against a database at a known state.
The recording and running of the Selenium tests is not within the scope of this website so I'm only looking for recommendations on how best to revert the database after each test execution.
- current database size is 30GB however only about 4GB needs to be reverted
- database is Oracle 11g Standard Edition running on Windows Server 2003
- the data in 6 different schemas needs to be reverted
Ideally the process should be scripted so that it can be re-executed frequently and automatically via a scheduled task.