重建ORACLE索引

declare

STR VARCHAR2(400);

begin

-- 重建ORACLE索引

FOR TMP_IDX IN (SELECT TABLESPACE_NAME, OWNER, TABLE_NAME, INDEX_NAME

FROM ALL_INDEXES-

WHERE OWNER = 'CPDB'

AND temporary = 'N' 

--AND TABLE_NAME = 'K_TASK'

--AND TABLESPACE_NAME <> 'CPDB_INDX'

ORDER BY TABLESPACE_NAME, TABLE_NAME) LOOP

STR := 'ALTER INDEX ' || TMP_IDX.OWNER || '.' || TMP_IDX.INDEX_NAME ||

' Rebuild Tablespace CPDB_INDX';

EXECUTE IMMEDIATE STR;

END LOOP;

end;