Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Snapshot of one schema into another schema

Re: Snapshot of one schema into another schema

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Fri, 5 May 2006 15:29:15 -0400
Message-ID: <52a152eb0605051229p2db6c73fr26c503e0e81249de@mail.gmail.com>


exp/imp is not an option as it would be too slow, and generate as much redo as my entire database. It must be a no-logging operation.

I dont have all month to rebuild the indexes, it will be used during that month period. Also rebuilding those indexes will consume resources on the machine.

To "pump" data without using a disk file you need a dblink. To pump data from 1 schema to another, you need a loopback dblink which is a dblink to the same database. I found no other way.

On 5/5/06, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
>
> Christo,
>
> I wouldn't rule out exp/imp. You are correct that the indexes would need to
> be rebuilt, but hey, you'd have a month to build them - right? Or maybe you
> wouldn't need all the indexes in your copy.
>
> Also consider transportable tablespaces. I could see that data pump would be
> worth considering. Not sure what you mean by network link (loopback dblink)
> with remap parameter. I'm lazy and for something that runs only once a
> month, I tend to want something that is durable and I don't have to fix it
> each month.
>
> Dennis Williams

--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 05 2006 - 14:29:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US