Re: datapump export to pipe
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: tony.adolph.dba@xxxxxxxxx
- Date: Tue, 6 Oct 2009 15:04:49 -0700 (PDT)
It's in 11gR1. The parameter is REUSE_DUMPFILES ... this will allow you to
re-use an existing dumpfile. As I've said before, I've not tested this with the
old compression methods (mknod, etc) but I would suspect it works.
RF
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
________________________________
From: Tony Adolph <tony.adolph.dba@xxxxxxxxx>
To: robertgfreeman@xxxxxxxxx
Cc: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>;
rjoralist@xxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Sent: Tue, October 6, 2009 3:46:52 PM
Subject: Re: datapump export to pipe
Hi Robert,
Original Poster here,...
RE:
Now, what I'm wondering is why you can't still do the piped compression
>with expdp? Frankly, I used to do it all the time with exp, but I've
>not tried it with expdp
See my Original post:
BUT,.. as you may have guessed, my plan is flawed as expdp doesn't
>allow writing to a file that already exists, and of course the pipe
>must (exist that is)
>
If the PIPE exists, which of course it must, the expdb complains that the file
already exists.
Tony
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)