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: