Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Alter index -- rebuild
Since the new 7.3 is out, I am having difficulty with rebuilding indexes on the fly. I use the Oracle help menu for alter index, but it seems to be incomplete. It doesn't like the initial parameter as well as the "rebuild tablespace PSINDEX". The error messages are not quite accurate and syntax from help entry is vague. What I have left is listed below:
alter index syshr.ps#accdnt_type_lng
pctfree 10
initrans 2 maxtrans 255
storage(
next 8k
minextents 1 maxextents 110 pctincrease 0) rebuild tablespace psindex;
TIA dmckinno_at_health-first.org Received on Mon Feb 17 1997 - 00:00:00 CST