Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index rebuild after unusable doesn't reuse space
Hi everybody.
I've noticed that after a
alter index t_i unusable;
if I issue an
alter index t_i rebuild;
Oracle leaves the space occupied by the index empty and allocates new
space. (Doubling the total space needed for the index).
Is it a normal behavior?
Is there a way to avoid this?
Thank you.
Kamal Received on Wed Jan 12 2005 - 05:23:52 CST