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;