SQL> select t.name,f.name
  2  from v$tablespace t,v$datafile f
  3  where t.ts# = f.ts#
  4  order by t.name;