DBA_INDEXES
DBA_INDEXES displays all indexes in the database. This view is accessible only to users with system administrator rights.
| 
        Column  | 
      
        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.