ORACLEÖؽ¨ËùÓеÄË÷Òý

declare­
  STR VARCHAR2(400);­
begin­
  -- Öؽ¨ORACLEË÷Òý­
  FOR TMP_IDX IN (SELECT TABLESPACE_NAME, OWNER, TABLE_NAME, INDEX_NAME­
                    from ALL_INDEXES­
                   WHERE OWNER = 'HNACMS'­
                     AND temporary = 'N'     ­
                     --AND TABLE_NAME = 'K_TASK'              ­
                     --AND TABLESPACE_NAME <> 'HNACMS_INDX'­
                   ORDER BY TABLESPACE_NAME, TABLE_NAME) LOOP­
    STR := 'ALTER INDEX ' || TMP_IDX.OWNER || '.' || TMP_IDX.INDEX_NAME ||­
           ' Rebuild Tablespace HNACMS_INDX';­
    EXECUTE IMMEDIATE STR;­
  END LOOP;­
end;­