| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> expdp size estimates
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 30 2006 - 05:40:18 CST
 |
 |