The DBA_INDEXES view lists all indexes in the database, including their owners, associated tables, uniqueness, and current status.
| Column | Type | Description |
|---|---|---|
owner | TEXT | Username of the index owner. |
schema_name | TEXT | Name of the schema containing the index. |
index_name | TEXT | Name of the index. |
index_type | TEXT | Included only for compatibility. Always BTREE. |
table_owner | TEXT | Username of the owner of the indexed table. |
table_name | TEXT | Name of the indexed table. |
table_type | TEXT | Included only for compatibility. Always TABLE. |
uniqueness | TEXT | Whether the index enforces uniqueness. Valid values: UNIQUE, NONUNIQUE. |
compression | CHARACTER(1) | Included only for compatibility. Always N (not compressed). |
tablespace_name | TEXT | Name of the tablespace in which the table is located, if this tablespace is not the default tablespace. |
logging | TEXT | Included only for compatibility. Always LOGGING. |
status | TEXT | Whether the index is usable. Valid values: VALID, INVALID. |
partitioned | CHARACTER(3) | Included only for compatibility. Always NO. |
temporary | CHARACTER(1) | Included only for compatibility. Always N. |
secondary | CHARACTER(1) | Included only for compatibility. Always N. |
join_index | CHARACTER(3) | Included only for compatibility. Always NO. |
dropped | CHARACTER(3) | Included only for compatibility. Always NO. |
Columns marked "Included only for compatibility" always return a fixed value and do not reflect the actual database state.