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 -> Re: Oracle8 index unusable

Re: Oracle8 index unusable

From: Patrick Tan <ptan_at_mindspring.com>
Date: 1998/01/05
Message-ID: <34B118C9.304B516E@mindspring.com>#1/1

It is a partition index , you have to rebuild a partition at a time,

alter index index_name rebuild partition partition1_name; alter index index_name rebuild partition partition2_name;
.
.
.

etc

This is actually a Oracle 8 bug, I applied Oracle 8.0.3.2 patch and it works now.

Patrick Received on Mon Jan 05 1998 - 00:00:00 CST

Original text of this message

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