DBA_INDEXES v11
The DBA_INDEXES view provides information about all indexes in the database.
| Name | Type | Description |
|---|---|---|
owner | TEXT | User name of the index’s owner. |
schema_name | TEXT | Name of the schema in which the index resides. |
index_name | TEXT | The name of the index. |
index_type | TEXT | The index type is always BTREE. Included for compatibility only. |
table_owner | TEXT | User name of the owner of the indexed table. |
table_name | TEXT | The name of the indexed table. |
table_type | TEXT | Included for compatibility only. Always set to TABLE. |
uniqueness | TEXT | Indicates if the index is UNIQUE or NONUNIQUE. |
compression | CHARACTER(1) | Always set to N (not compressed). Included for compatibility only. |
tablespace_name | TEXT | Name of the tablespace in which the table resides if other than the default tablespace. |
logging | TEXT | Included for compatibility only. Always set to LOGGING. |
status | TEXT | Whether or not the state of the object is valid. (VALID or INVALID). |
partitioned | CHARACTER(3) | Indicates that the index is partitioned. Always set to NO. |
temporary | CHARACTER(1) | Indicates that an index is on a temporary table. Always set to N. |
secondary | CHARACTER(1) | Included for compatibility only. Always set to N. |
join_index | CHARACTER(3) | Included for compatibility only. Always set to NO. |
dropped | CHARACTER(3) | Included for compatibility only. Always set to NO. |