COL FILE_NAME FORMAT A60 SELECT TABLESPACE_NAME,FILE_NAME,BYTES/1024/1024 "MB" from dba_data_files order by tablespace_name,file_name /