chintu414

• Oct 30th, 2007

 

select d.name , t.name from v$datafile d, v$tablespace t where d.ts#=t.ts#;

ravichandiran

• Nov 16th, 2007

 

run this query in the sql prompt

sql> select tablespace_name,file_name from dba_data_files;

cmanne

 Profile Answers by cmanne 

• Sep 2nd, 2009

 

select file_name, tablespace_name
from
dba_data_files;