CODE EXAMPLE FOR SQL

VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE

SELECT index_owner, index_name, partition_name, tablespace_name,status
FROM dba_ind_PARTITIONS;