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: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Fri, 5 May 2006 22:52:24 +0200
Message-ID: <018b01c67085$d33b06a0$cb00a8c0@MPILA9>


> 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.

TTS if all requirements are met.

Regards,
Dimitre

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 05 2006 - 15:52:24 CDT

Original text of this message

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