How to find which tablespace belongs to which datafile ?

Showing Answers 1 - 3 of 3 Answers


  • Oct 30th, 2007

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

  Was this answer useful?  Yes


  • Nov 16th, 2007

run this query in the sql prompt

sql> select tablespace_name,file_name from dba_data_files;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions