Free space for all tablespaces

I just want a SQL query to give me the freespace in all tablespaces. This doesn't work:

select a.tablespace_name, sum(a.bytes) TOTAL_SPACE, sum(b.bytes)a FREE_SPACE from sys.dba_data_files a, sys.dba_free_space b where a.tablespace_name = b.tablespace_name group by 1;

Does anyone have a query that does work??

thanks,

..tom Received on Tue Jul 11 2000 - 07:50:03 CDT