Re: expdp size estimates

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 30 Mar 2006 07:56:59 -0500
Message-ID: <9177895d0603300456k16ce26eam3bccd49b6837cd67@mail.gmail.com>

okay ... one metalink note (268167.1) explains that the size is calculated as blocks multiplied by blocksize. It completely ignores the COMPRESSED flag.

hmmm ...
Raj

On 3/30/06, rjamya <rjamya_at_gmail.com> wrote:
> I have a largish (?) table that I wanted to export using expdp
> (10.1.0.4). This table is partitioned and compressed and has about
> 700m rows.
>
> Compressed size of this table is ~90gb, when I used expdp with
> ESTIMATE_ONLY option, it came back with total estimaetd file size of
> about 92.6gb. Since I was skeptical, I tried to do a trial export and
> guess what ... the total export size was about 240GB+.
>
> Now, it isn't close to 92gb. So, in your experience, does oracle just
> report blocks allocated blindly without checking for COMPRESSED flag
> on the table?
>
> Oh and if you haven't been burnt by this already, if you have more
> than 256 partitions, it fails with ora-1426, looks like another y2k
> problem in the making to me.
>
> tia for input
> Raj
> ----------------------------------------------
> Got RAC?
>

--
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 30 2006 - 06:56:59 CST