Re: Testing schema reset as night service ?

On Mar 20, 4:24 am, "timo" <timo.ta..._at_luukku.com> wrote:
> 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

Hi Timo,

In addition to what others have posted, lookup flashback database.

HTH, Steve Received on Thu Mar 20 2008 - 17:51:24 CDT