RE: datapump export to pipe
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Oct 2009 11:48:27 -0400
>> 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:
- » datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- ~Jeff~
- » RE: datapump export to pipe- D'Hooge Freek
- » RE: datapump export to pipe- Riku Räsänen
- » Re: datapump export to pipe- Joey D'Antoni
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Guillermo Alan Bort
- » Re: datapump export to pipe- Guillermo Alan Bort
- » Re: datapump export to pipe- Christoph
- » RE: datapump export to pipe - Powell, Mark D
- » RE: datapump export to pipe- Adams, Matthew (GE Indust, ConsInd)
- » RE: datapump export to pipe- Jost,
- » Re: datapump export to pipe- Jared Still
- » RE: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Powell, Mark D
- » Re: datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » RE: datapump export to pipe- MacGregor, Ian A.
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Joey D'Antoni
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Adric Norris
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Dunbar, Norman
- » RE: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Dunbar, Norman
- » RE: datapump export to pipe- Mercadante, Thomas F (LABOR)
- » RE: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Robert Freeman
- » RE: datapump export to pipe- Mercadante, Thomas F (LABOR)