Diffrence for estimates size using query and for expdp
Hello
We have one large table with millions of rows and when we check size of this table using query as below
select sum(bytes)/1024/1024/1024 "size in GB" from user_segments where segment_name='MYTABLE';
we got expected size 17GB.
We have one large table with millions of rows and when we check size of this table using query as below
select sum(bytes)/1024/1024/1024 "size in GB" from user_segments where segment_name='MYTABLE';
we got expected size 17GB.
However, when we exported the table using EXPDP it showed estimated size as 34GB.
Can anyone help me identifying why the diffrence is there for expected tablesize in GB?
Note: Table consits of BLOB datatype column
Database version: Oracle10G
OS: Sun Solaris10
Thanks
0