SQL

VERIFY INDEXES IN SQL ORACLE

SELECT owner, index_name, tablespace_name,status
FROM dba_indexes;