Testing schema reset as night service ?

From: timo <timo.talja_at_luukku.com>
Date: Thu, 20 Mar 2008 08:24:44 GMT
Message-ID: <gbpEj.36$2f2.28@read4.inet.fi>

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

Original text of this message