set pagesize 1000
set linesize 132
set heading off
set feedback off
col file_name form a65
col ts form a12
col mb form 9,999

select tablespace_name ts, file_name, bytes/1024/1024 mb 
from dba_data_files 
order by file_id
/

set heading on
set feedback on