查临时表空间对应的数据文件

col file for a30
col tablespace for a25
select f.file#,t.ts#,f.name "File",t.name "Tablespace" from v$tempfile f,V$tablespace t where f.ts# = t.ts# /