Re: Testing schema reset as night service ?

On Mar 20, 1: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

You might look into transportable tablespaces and rman options, depending on whether you are wanting to refresh from live data or some stable data set. Remember rman can restore tablespaces to a point in time. I've heard some people are using flashback.

It all really depends what you are doing. You should have some test data that includes bad data and data that comes near and goes over functional design limits, and some that reflects actual data distributions and values.

I'm always wishing I had time to do it right...

jg

--
@home.com is bogus.
awk 'BEGIN { q="'"'"'";print "Never say can"q"t."; exit }'