Show files for a given tablespace

 set linesize 160
 set wrap off
 column name format a20
 column filename format a50
 
 select ts.name, df.name as FILENAME
 from V_$TABLESPACE ts, V_$DATAFILE df
 where df.TS# = ts.TS#
 order by ts.name , df.name;