Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Pump and compression

RE: Data Pump and compression

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Fri, 28 Sep 2007 10:19:46 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8C51@x6009a.umb.corp.umb.com>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Friday, September 28, 2007 9:28 AM To: oracle-l_at_freelists.org
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
Received on Fri Sep 28 2007 - 10:19:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US