RE: datapump export to pipe

From: Adams, Matthew (GE Indust, ConsInd) <"Adams,>
Date: Tue, 6 Oct 2009 11:59:50 -0400
Message-ID: <>

Are you sure about the statement that exp goes away with 11g?  

I've got a couple of 11g installations ( 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: [] On Behalf Of Powell, Mark D Sent: Tuesday, October 06, 2009 11:48 AM To:
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: [] On Behalf Of Guillermo Alan Bort
	Sent: Tuesday, October 06, 2009 11:02 AM
	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 ^_^
	Alan Bort
	Oracle Certified Professional
	On Tue, Oct 6, 2009 at 10:46 AM, Rich Jesse <> 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...

> The compression option in 11.1 (and 2) allows for compression of data pump
> exports, but it costs $$ or €€ ...
Received on Tue Oct 06 2009 - 10:59:50 CDT

Original text of this message