RE: Data Pump and compression

You can compress metadata AND/OR data with datapump.
When I was testing it, I saw some pretty significant
numbers on compression of database data. Don't have
exact ones but well over 10-15%. (over 50% as I recall
in my test).

Again the question is licensing. I'm not sure if this
is covered in the compression license or not.

RF

--- "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx> wrote:

> 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%.
> >
> 
> 
> --
> http://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.
> 
>
==============================================================================
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 


Robert G. Freeman
Author:
Now Available for Pre-Sales on Amazon.com!!!!
**************************************************
Oracle Database 11g New Features (Oracle Press)
**************************************************
Portable DBA: Oracle  (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)
--
http://www.freelists.org/webpage/oracle-l


Other related posts: