index2

BEGIN
  FOR idx IN (
    SELECT index_name 
    FROM user_indexes 
    WHERE table_name = 'SEQUENCE' AND status='UNUSABLE'
  ) LOOP
    EXECUTE IMMEDIATE 'ALTER INDEX "' || idx.index_name || '" REBUILD';
  END LOOP;
END;
/