expdp estimate_only=y vs dba_segments
BoochiMar 6 2009 — edited Mar 6 2009Hi,
I'm calculating the schema size for the export. I have run expdp estimate_only=y. This has given the estimated size as 8G. I have also run the query under dba_segments.
select sum(bytes)/1024/1024/1024 as size_gig, segment_type
from dba_segments where owner='TEST' group by segment_type;
The query has returned index space as 11G and table space as 8G. It means, the expdp has not included the index space. Won't expdp export index data?. If so, will it rebuild all the indexes as part of import?.