> 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