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