Unusable index

	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_owner = 'AAA'
	AND status = 'UNUSABLE'
	;