Re: Testing schema reset as night service ?
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 20 Mar 2008 19:51:13 +0100
Message-ID: <10376$47e2b222$524b5c40$17891@cache2.tilbu1.nb.home.nl>
>
> 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
Yet another idea, suited for large amounts of data (import would take too long):
Use transportable tablespaces - all you import then, is the metadata - you just copy the datafile(s) with all data from another location.
Date: Thu, 20 Mar 2008 19:51:13 +0100
Message-ID: <10376$47e2b222$524b5c40$17891@cache2.tilbu1.nb.home.nl>
gazzag wrote:
> 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
Yet another idea, suited for large amounts of data (import would take too long):
Use transportable tablespaces - all you import then, is the metadata - you just copy the datafile(s) with all data from another location.
Works for data only; if you have any source code that should be reset, this does not work
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Thu Mar 20 2008 - 13:51:13 CDT