Re: How to sum dba_data_files by tablespace? Help!!

Simply put your entire select statement within a from clause of another select statement.
ie select tablespace_name, sum(free_mb)
from (Select ...)
group by tablespace_name;
Also remember to remove your order by clause in the inner Select clause. Received on Tue Dec 21 2004 - 09:28:39 CST