Re: Restoration of DB to pre-test state ???

If you mean the particular "schema", i.e. tables and data for the application under test, the easiest way is to export the Oracle user owning the data. Once the test is complete drop all objects (or just delete all data) for that user and import the user.

Otherwise for the entire physical database, you would need to have automated scripting for exporting the entire database, dropping the db, deleting all of the files, recreating the db and all tablespaces and importing the entire db, (no small task).

V.

-- 
#include usual disclamers, warrenties, and other lies