Re: expdp size estimates
- From: rjamya <rjamya@xxxxxxxxx>
- To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Mar 2006 07:56:59 -0500
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@xxxxxxxxx> 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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
