RE: Data Pump and compression

  • From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
  • To: rjoralist@xxxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 28 Sep 2007 10:19:46 -0500

Shrinking the metadata wouldn't help a lot, its just not that big.

We export through a pipe and use gzip to compress it, and get pretty
good compression of standard export files,  I expect it would work with
datapump files also if you are only using one output file.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich Jesse
Sent: Friday, September 28, 2007 9:28 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Data Pump and compression

That's very poor compression.  I hope it's a typo in the docs!  Anyone
messed with this yet???

Rich

> Check out section 1.3.1 at
>
http://download.oracle.com/docs/cd/B28359_01/server.111/b28279/chapter1.
htm#FEATURENO06982
>
> "
> Data Pump provides the ability to compress the metadata of a dump file
set,
> which can shrink the dump files by 10-15%.
>


--
//www.freelists.org/webpage/oracle-l



------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  
The information is exclusively for the use of the individual or entity intended 
as the recipient.  If you are not the intended recipient, any use, copying, 
printing, reviewing, retention, disclosure, distribution or forwarding of the 
message or any attached file is not authorized and is strictly prohibited.  If 
you have received this electronic mail message in error, please advise the 
sender by reply electronic mail immediately and permanently delete the original 
transmission, any attachments and any copies of this message from your computer 
system. Thank you.

==============================================================================

--
//www.freelists.org/webpage/oracle-l


Other related posts: