Re: datapump export to pipe

  • From: Robert Freeman <robertgfreeman@xxxxxxxxx>
  • To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx, Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 Oct 2009 07:53:39 -0700 (PDT)

Hey Thomas....

The issue with compress is that it requires you buy a separate license.

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



----- Original Message ----
From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, October 7, 2009 8:17:48 AM
Subject: RE: datapump export to pipe

Sorry to weigh in late on this - but did anyone look at expdp with the 
compression option?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Dunbar, Norman
Sent: Wednesday, October 07, 2009 10:08 AM
To: Oracle-L
Subject: RE: datapump export to pipe

Hi Rich,

>> ...

>> So, it seems that exp/imp (or my new favorite expdp/impdp) 
>> is the way to go.

I must have missed a posting, does this mean that you have found a way
to compress "on the fly" down a pipe then? I only recall posters saying
that it can't be done and if you use the option to replace the dump
files, you get an error on pipes.

Have I missed something then?


Cheers,
Norm.



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

Other related posts:

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