Re: Testing schema reset as night service ?

From: gazzag <gareth_at_jamms.org>
Date: Thu, 20 Mar 2008 04:01:38 -0700 (PDT)
Message-ID: <d2a497bb-b801-4e8a-afad-a4e9fd653c0c@i12g2000prf.googlegroups.com>


On 20 Mar, 08:24, "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

Oracle version? Received on Thu Mar 20 2008 - 06:01:38 CDT

Original text of this message