Testing schema reset as night service ?

Hi,
Any proposals how to reset schema used for testing purposes every night ?

Idea is to clear db from test cases made during working day.

Does it go like this - and what are alternative ways (tools ?) to do it:
-exp a dmp when db is clear
-at nighttime run a .sh script to remove that testing schema
-imp that schema from dmp

BR, Timo Received on Thu Mar 20 2008 - 03:24:44 CDT