-- created on 2012-5-24 by administrator
declare
cursor jl is select * from user_indexes a where a.status='unusable';
begin
for r in jl loop
execute immediate 'alter index '||r.index_name ||' rebuild';
end loop;
end;
-- created on 2012-5-24 by administrator
declare
cursor jl is select * from user_indexes a where a.status='unusable';
begin
for r in jl loop
execute immediate 'alter index '||r.index_name ||' rebuild';
end loop;
end;
![Oracle索引内部结构研究[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)