-
Hi guys,
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]
Reddy,Sam
-
if your question is how to rebuild indexes then,
alter index emp_idx rebuild
storage(initial 10M next 5M pctincrease 0)
tablespace INDX_1;
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|