Database Administration - how to find which tablespace belongs to which datafile ?

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 136 of 231

how to find which tablespace belongs to which datafile ?

Total Answers and Comments: 3

Last Update: September 02, 2009 Asked by: sushil k

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 30, 2007 18:38:51

chintu414

RE: how to find which tablespace belongs to which da...

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

Is this answer useful? Yes | No

November 16, 2007 02:15:57

ravichandiran

RE: how to find which tablespace belongs to which da...

run this query in the sql prompt

sql> select tablespace_name file_name from dba_data_files;

Is this answer useful? Yes | No

September 02, 2009 17:21:18

cmanne

Member Since: January 2006 Contribution: 49

RE: how to find which tablespace belongs to which datafile ?

select file_name tablespace_name
from
dba_data_files;

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank