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.
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-lReceived on Fri May 05 2006 - 14:29:15 CDT