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.

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';