Indexes

[cravi]

Hi All,

I have an Index tablespace with 10 datafiles.
How to find what indexes are there in each datafile?

Need a report like :

Datfile 001 --- Index1
Index 2

Datafile002 --- Index 6
Index 7

Can you please provide some query.

Thanks in Advance..

[Shestakov]

see view DBA_EXTENTS and field FILE_ID

[cravi]

Can you please be more explicit.
I need some query to find which indexes are there in which datafile.

Thanks

[abhaysk]

Originally posted by cravi
Can you please be more explicit.
I need some query to find which indexes are there in which datafile.

Thanks

select D.FILE_NAME,e.file_id from dba_data_files D, dba_extents E where e.FILE_ID=d.FILE_ID
and e.SEGMENT_NAME='Your_INDEX_NAME' and e.SEGMENT_TYPE='INDEX';