RE: datapump export to pipe

  • From: "Adams, Matthew (GE Indust, ConsInd)" <MATT.ADAMS@xxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Oct 2009 11:59:50 -0400

Are you sure about the statement that exp goes away with 11g?
 
I've got a couple of 11g installations (11.1.0.7 in Itanium based HP-UX) and 
they all have 'exp'.
 
I've not installed any 11.2 systems yet.   
 
Does exp go away with 11.2?

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Powell, Mark D
Sent: Tuesday, October 06, 2009 11:48 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: datapump export to pipe


>> Oracle STILL PROVIDES regular export. <<
 
Not with 11g.  Only imp is provided to allow loading old exp dmp files into the 
database.  The exp utility is now history though I am sure a lot of sites 
running 10g and lower will still be using exp for a few more years.
 

-- Mark D Powell -- 
HP Enterprise Services 
Phone (313) 592-5148 

 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Guillermo Alan Bort
        Sent: Tuesday, October 06, 2009 11:02 AM
        To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
        Cc: oracle-l@xxxxxxxxxxxxx
        Subject: Re: datapump export to pipe
        
        
        Actually, Oracle STILL PROVIDES regular export. So if you want to 
compress an export, you can use the regular export.
        
        If you have the space and time is an issue, then you have dp... 
        
        I don't think Oracle is an evil corporation that did this on purpose, I 
do think that oracle is a business and as such tries to make many any way it 
can.
        
        Anyway, I hate working with compressed export files, so I am happy that 
it can no longer be done with dp ^_^
        
        cheers.
        Alan Bort
        Oracle Certified Professional
        
        
        
        On Tue, Oct 6, 2009 at 10:46 AM, Rich Jesse 
<rjoralist@xxxxxxxxxxxxxxxxxxxxx> wrote:
        

                True.  And I think it's reprehensible for Oracle Corp to take 
this
                functionality away when moving from exp to dp, and then turn 
around and
                charge extra for it in the next version.  But I digress...
                
                One alternative may be to use a filesystem's internal 
compression, perhaps
                JFS or ZFS.  For example, creating a new volume specifically 
for datapump
                exports, initializing it with a compression-enabled 
filessystem, and using
                that to store datapump exports.
                
                I haven't tried this.  It's just a thought...
                
                Rich
                

                > The compression option in 11.1 (and 2) allows for compression 
of data pump
                > exports, but it costs $$ or €€ ...
                
                
                
                --
                //www.freelists.org/webpage/oracle-l
                
                
                


Other related posts: