how to rebuilt partioned table index
702714Sep 3 2009 — edited Sep 3 2009Hi all,
I am supporting a 10g production server .
I have to rebuilt my indexe.
But when i am running this query
DECLARE
CURSOR c_index IS
SELECT index_name from user_indexes where index_name not like '%$%';
v_text VARCHAR2(4000);
BEGIN
FOR r_index IN c_index
LOOP
v_text := 'ALTER INDEX '||r_index.index_name ||' REBUILD ';
EXECUTE IMMEDIATE v_text;
END LOOP;
END;
/
i am getting a error that partioned index can't be rebuilt as a whole...
kindly help me out as i am new to this.
Thanks in advance...