Rebuild all indexes once


declare
index_name VARCHAR2(100);
CURSOR i_c is select index_name from user_indexes;
begin
open i_c;
loop
fetch i_c into index_name;
EXIT WHEN i_c%NOTFOUND;
EXECUTE IMMEDIATE ('alter index ' || index_name || ' rebuild');
end loop;
end;