How to find which tablespace belongs to which datafile ?

Showing Answers 1 - 3 of 3 Answers

chintu414

  • Oct 30th, 2007
 

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

  Was this answer useful?  Yes

ravichandiran

  • 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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions