SELECT * FROM dba_ind_partitions -- 그냥 index면 dba_indexes WHERE index_owner = 'AAA' AND status = 'UNUSABLE' --ALTER INDEX AA_IDX REBUILD PARTITION SYS_P313859; --ALTER INDEX AA_IDX2 REBUILD PARTITION P2019_07 ONLINE PARALLEL 32 NOLOGGING SELECT 'ALTER INDEX ' || index_name || ' REBUILD PARTITION '|| PARTITION_NAME || ';' AS ALTER_STMT FROM dba_ind_partitions -- 그냥 index면 dba_indexes WHERE index_..