Re: Testing schema reset as night service ?
From: gazzag <gareth_at_jamms.org>
Date: Thu, 20 Mar 2008 04:47:49 -0700 (PDT)
Message-ID: <fed4e202-4d8d-41d2-acae-b1a2133e61f8@h11g2000prf.googlegroups.com>
Date: Thu, 20 Mar 2008 04:47:49 -0700 (PDT)
Message-ID: <fed4e202-4d8d-41d2-acae-b1a2133e61f8@h11g2000prf.googlegroups.com>
On 20 Mar, 11:09, "timo" <timo.ta..._at_luukku.com> wrote:
>
> 10.2; linux
I have certainly done as you have suggested and it works quite well. Namely:
- drop and recreate the schema
- import into the schema
Another method would be:
- truncate tables in target schema
- repopulate target schema from source schema using either INSERT over a database link or INSERT from <source_schema>.<table_name> etc...
HTH -g Received on Thu Mar 20 2008 - 06:47:49 CDT