How can I rebuild the existing index file?
Thanks in advance.
If its version 734 and above not 72 you can use REBUILD clause. SORRY, I have pasted the wrong syntax before and din't notice... here you go with right one.
alter index XYZ.ABC_IX rebuild;
[Edited by sreddy on 03-01-2001 at 04:42 PM]
if your question is how to rebuild indexes then,
alter index emp_idx rebuild
storage(initial 10M next 5M pctincrease 0)
Click Here to Expand Forum to Full Width