Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Snapshot of one schema into another schema
> 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-lReceived on Fri May 05 2006 - 15:52:24 CDT