RE: datapump export to pipe

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 Oct 2009 08:34:47 -0500 (CDT)

Norm!

> 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

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2009