Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8 index unusable
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