Re: Doubt about Datapump - Compression

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sun, 30 Dec 2007 07:29:10 -0800 (PST)
Message-ID: <2f400dff-1cd8-44bc-b3fb-be3a65070386@n20g2000hsh.googlegroups.com>


On Dec 30, 7:26 am, "lyx..._at_gmail.com" <lyx..._at_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

If I remember correctly the compression was added in 10.2 and as you noted applied only to metadata ( making it not so useful ).

In 11g however I think compression applies to data as well as metadata. Received on Sun Dec 30 2007 - 09:29:10 CST

Original text of this message