incongruencies between dba_data_files , dba_segments and dba_free_space
Andrea MDec 18 2007 — edited Dec 18 2007Hi all,
I run this query:
select sum(bytes), 'USED' from dba_segments where tablespace_name = '&tsname' union
select sum(bytes), 'FREE' from dba_free_space where tablespace_name = '&tsname' union
select sum(bytes), 'TOTL' from dba_data_files where tablespace_name = '&tsname';
and I get as a result:
220200960 FREE
10989076480 USED
11010048000 TOTL
So, free_space + used_space is LESS than the space occupied by the datafiles! Why ?
If I try to query sum(blocks) instead of sum(bytes) I get the same results... So: how can I get more space than the existing one?
Thaks for every reply,
andrea