datafile3.sql

rem  dfile.sql
rem
ttitle 'Data Files by File Name'
rem
col tablespace_name format a18 heading 'TABLESPACE'
col file_id format 999 heading 'ID'
col bytes format 9999999999
col blocks format 9999999
col status format a9
col file_name format a25 heading 'FILE NAME'
rem
break on tablespace_name
rem
select tablespace_name, file_id, bytes, blocks,
       decode( status, 'AVAILABLE', null, status ) status, file_name
  from sys.dba_data_files
 order by file_name;