Re: datapump export to pipe
Date: Wed, 7 Oct 2009 07:53:39 -0700 (PDT)
The issue with compress is that it requires you buy a separate license.
Robert G. Freeman
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
- 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?
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
>> 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?