Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Alter index -- rebuild

Alter index -- rebuild

From: D.L. McKinnon <McKinnon_at_ix.netcom.com>
Date: 1997/02/17
Message-ID: <3308da9c.473288@nntp.ix.netcom.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US