I want to find the size of schema in Oracle 11g exported using expdp command as we take backup of the couple of schemas during downtime and the time taken by backup affects the downtime. This goes with the understanding that if there is a table with 1 MB extent but no data, dba_segments would report 1Mb and expdp would report 0 bytes which means expdp takes into consideration the actual data exported and not the allocation.
I hope, I have been able to explain the query as to how to find the size of schema exported using expdp as that directs affects the downtime.
Requesting a reply to my post.
Regards