重建用户下的所有索引

重建用户下的所有索引

DECLARE
  STR VARCHAR2(400);
BEGIN
  FOR TMP_IDX IN (SELECT OWNER,
                         INDEX_NAME
                    FROM ALL_INDEXES
                   WHERE OWNER = 'CARMOT_TRIGGER' AND
                         TEMPORARY = 'N') LOOP
    STR := 'ALTER INDEX ' || TMP_IDX.OWNER || '.' || TMP_IDX.INDEX_NAME ||
           ' REBUILD ONLINE';
    EXECUTE IMMEDIATE STR;
  END LOOP;
END;