Re: Testing schema reset as night service ?
Date: Thu, 20 Mar 2008 15:51:24 -0700 (PDT)
On Mar 20, 4:24 am, "timo" <timo.ta..._at_luukku.com> wrote:
> 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
In addition to what others have posted, lookup flashback database.
HTH, Steve Received on Thu Mar 20 2008 - 17:51:24 CDT