Team,
Let's consider our basic scott schema for this scenario.
When we take the dump for this user and from the log file we see the size as 50MB(approximately).
But when we calculated the size using the below query we get around 500 MB(approximately).
Query used :
select table_name, num_rows, (bytes/1024/1024/1024) GB from dba_tables t Inner
join dba_segments s On table_name=segment_name and t.owner=s.owner Where segment_type='TABLE' And s.owner='SCOTT'
ORDER BY 3 DESC;
Please let us know where we are getting mistaken.
Regards,
Satyam Reddy