OraFAQ Forum: Server Administration » To check tables located in which datafiles

Home » RDBMS Server » Server Administration » To check tables located in which datafiles (10.2.0.4.0 HP-UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To check tables located in which datafiles [message #469873]

Fri, 06 August 2010 03:43

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

Hi all, would want to check which tables located in which datafiles.

Tried with this command:
select B.FILE_NAME from dba_segments a, dba_data_files b
where a.header_file=b.file_ID and segment_name='TABLE_NAME'

Seems like it only shows 1 datafile. Some tables are large and i suppose it's resided in more than 1 datafile.

Pls help. Thanks!

Report message to a moderator