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