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:
- » datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- ~Jeff~
- » RE: datapump export to pipe- D'Hooge Freek
- » RE: datapump export to pipe- Riku Räsänen
- » Re: datapump export to pipe- Joey D'Antoni
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Guillermo Alan Bort
- » Re: datapump export to pipe- Guillermo Alan Bort
- » Re: datapump export to pipe- Christoph
- » RE: datapump export to pipe- Powell, Mark D
- » RE: datapump export to pipe- Adams, Matthew (GE Indust, ConsInd)
- » RE: datapump export to pipe- Jost,
- » Re: datapump export to pipe- Jared Still
- » RE: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Powell, Mark D
- » Re: datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » RE: datapump export to pipe- MacGregor, Ian A.
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Joey D'Antoni
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Adric Norris
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Dunbar, Norman
- » RE: datapump export to pipe - Rich Jesse
- » RE: datapump export to pipe- Dunbar, Norman
- » RE: datapump export to pipe- Mercadante, Thomas F (LABOR)
- » RE: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Robert Freeman
- » RE: datapump export to pipe- Mercadante, Thomas F (LABOR)