Re: datapump export to pipe
Date: Wed, 7 Oct 2009 07:53:39 -0700 (PDT)
Message-ID: <449496.61617.qm_at_web38906.mail.mud.yahoo.com>
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_at_labor.state.ny.us> To: Oracle-L <oracle-l_at_freelists.org> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 07 2009 - 09:53:39 CDT