Finding tablespaces and their associated data-files

select substr(b.name,0,10) name, a.file#, a.ts#, status, from v$datafile a, v$tablespace b where a.ts#=b.ts#
Order by file#