RE: datapump export to pipe

> Not much use, I admit, if you only want a subset of the schemas in your
> production database, but we clone the lot.

Bingo! We have three "lower" environments in one database for Dev/Test/QA and Prod has ERP system and metadata in multiple schemas in the same DB as production data (makes for interesting shared pool patterns and backup/recovery scenarios).

Plus, the table and index layouts will usually differ between Production and the other three, meaning that I need to keep or recreate them after a data copy or JDEdwards will bark loudly.

So, it seems that exp/imp (or my new favorite expdp/impdp) is the way to go.  And I've done a few things like manual parallelism (multiple concurrent exp/imp) to help speed up the process.

Thanks!
Rich

--
http://www.freelists.org/webpage/oracle-l