set echo off
col Tablespace  for a20
col "File Name" for a44
col "File ID" heading File|ID    for 999
col round((bytes)/(1024*1024),2) for 9999.99
col "Total Space (MB)" heading Total|Space(MB) for 9999.99
select tablespace_name "Tablespace", file_name "File Name",
file_id "File ID", round((bytes)/(1024*1024),2) "Total Space (MB)"
from sys.dba_data_files
union
select tablespace_name "Tablespace", file_name "File Name",
file_id "File ID", round((bytes)/(1024*1024),2) "Total Space (MB)"
from sys.dba_temp_files 
order by 1,2;
set echo on