List all indexes from Oracle database

How to list all indexes from Oracle database

To list all indexes from Oracle database or from an specific table you can use: USER_INDEXES, ALL_INDEXES, DBA_INDEXES, USER_OBJECTS.
Privileges may be required to run some of the queries in the example below.

Examples

  
SELECT * FROM USER_INDEXES;

SELECT * FROM USER_INDEXES 
WHERE TABLE_OWNER='SYSTEM';

SELECT * FROM USER_INDEXES 
WHERE TABLE_OWNER='SYSTEM' 
AND TABLE_NAME='STUDENTS_LIST';

SELECT * FROM ALL_INDEXES;

SELECT * FROM ALL_INDEXES 
WHERE TABLE_OWNER='SYSTEM';

SELECT * FROM DBA_INDEXES;

SELECT * FROM DBA_INDEXES 
WHERE TABLE_OWNER='SYSTEM';

SELECT * FROM USER_OBJECTS 
WHERE OBJECT_TYPE = 'INDEX';