Get owner, index_name and status for DBA_indexes
SQL> select Owner, /*Owner of the index*/
2 Index_Name, /*Name of the index*/
3 Status /*Either DIRECT PATH or VALID*/
4 from DBA_INDEXES
5 where rownum < 10
6 /
OWNER INDEX_NAME STATUS
------------------------------ ------------------------------ --------
XDB XDBHI_IDX VALID
DEFINER SYS_IOT_TOP_16249 VALID
INV20 SYS_IOT_TOP_16247 VALID
INV19 SYS_IOT_TOP_16245 VALID
INV18 SYS_IOT_TOP_16243 VALID
INV17 SYS_IOT_TOP_16241 VALID
INV16 SYS_IOT_TOP_16239 VALID
INV14 SYS_IOT_TOP_16235 VALID
INV13 SYS_IOT_TOP_16233 VALID
Related examples in the same category