DBA_INDEXES
DBA_INDEXES displays all indexes in the database. This view is accessible only to users with system administrator rights.
Name |
Type |
Description |
---|---|---|
owner |
character varying(64) |
Index owner |
index_name |
character varying(64) |
Index name |
table_name |
character varying(64) |
Name of the table corresponding to the index |
uniqueness |
text |
Whether the index is unique |
generated |
character varying(1) |
Whether the index name is generated by the system |
partitioned |
character(3) |
Whether the index has the property of the partition table |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.