DECLARE cursor the_index IS SELECT index_name FROM all_indexes WHERE tablespace_name = ''; BEGIN FOR name IN the_index LOOP EXECUTE IMMEDIATE 'alter index '||name.index_name||' rebuild'; END LOOP; END;