Re: Testing schema reset as night service ?
From: timo <timo.talja_at_luukku.com>
Date: Thu, 20 Mar 2008 11:09:57 GMT
Message-ID: <9CrEj.74$2f2.46@read4.inet.fi>
Date: Thu, 20 Mar 2008 11:09:57 GMT
Message-ID: <9CrEj.74$2f2.46@read4.inet.fi>
"gazzag" <gareth_at_jamms.org> wrote in message
news:d2a497bb-b801-4e8a-afad-a4e9fd653c0c_at_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?
10.2; linux Received on Thu Mar 20 2008 - 06:09:57 CDT