Path: news.netfront.net!ctu-peer!news.nctu.edu.tw!club-internet.fr!feedme-small.clubint.net!news.ecp.fr!news.greatnowhere.com!reader.greatnowhere.com!not-for-mail
From: Mladen Gogala <mgogala@yahoo.com>
Subject: Re: Doubt about Datapump - Compression
Newsgroups: comp.databases.oracle.server
References: <f0063268-f949-43f5-91b1-0081612c567e@e25g2000prg.googlegroups.com>
User-Agent: Pan/0.132 (Waxed in Black)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Date: 01 Jan 2008 12:14:11 GMT
Lines: 61
Message-ID: <477a2e93$0$1344$834e42db@reader.greatnowhere.com>
NNTP-Posting-Date: 01 Jan 2008 12:14:11 GMT
NNTP-Posting-Host: 0a3fb59b.reader.greatnowhere.com
X-Trace: DXC=TkY\<QK<UPb^\W>5k`DJDb]XKbj2VKD@jn1RJ3gdIg\kgWXZZke`H:i2h=o9Y@GCb`55:h3U91eThU]V1IaTm@^d9KN3[3CLNNlSfG9c<VCLJi<l:Ho56m3_d`2XEoX:61b`gSbL4N4>SGca7e3>I8nLdbQba_0XKK1S`cUHefITeYOeFo^6E5kX=Gn
X-Complaints-To: usenet@greatnowhere.com
Xref: news.netfront.net comp.databases.oracle.server:180734

On Sun, 30 Dec 2007 05:26:12 -0800, lyxx09@gmail.com wrote:

> Hi All,
> 
> I have been reading about the datapump and came to know about
> "compression"
>  parameter.
> 
> As per doc it will compress all the metadata before writing it out to
> the
> dump file. which is default.
> 
> But I could not understand the benefit of this if this is just for
> metadata
> not the real data because metadata's size is just negligible as compare
> to whole database.
> 
> Could you identify any other case where it is useful.
> 
> Happy New Year 2008 !!
> 
> Regards,
> Lyx

Happy New Year 2008. Oracle does support full compression, but only if
you install what amounts to the latest patchset, according to D. Morgan.
That latest patchset is called oracle11. Here is an exceprt from the 
utilities manual:

COMPRESSION

Default: METADATA_ONLY

Purpose

Specifies which data to compress before writing to the dump file set.

Syntax and Description

COMPRESSION={ALL | DATA_ONLY | METADATA_ONLY | NONE}

    *

      ALL enables compression for the entire export operation.
    *

      DATA_ONLY results in all data being written to the dump file in 
compressed format.
    *

      METADATA_ONLY results in all metadata being written to the dump 
file in compressed format. This is the default.
    *

      NONE disables compression for the entire export operation.




-- 
http://mgogala.freehostia.com