Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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