| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index unusable after rebuild
> -----Original Message-----
> Was wondering what may be the cause for it.
>
> 9.2.0.1.0 on Win2k.
Since nobody else has replied, I'll say what little I know. (I hope you don't mind if I change the thread/subject.)
I see your version is 9.2.0.1. As much as we all know and love Oracle, and are convinced of its absolute infallibility, it is fact that there were some very nasty bugs in version 9. Some of these were that things that were supposed to be online were not. When we originally "upgraded" to 9, our production systems ended up in a ditch more than once because of memory fragmentation and online maintenance that was only sort of -- but not quite -- online. I don't recall the versions where the problems exist. 9.2.0.4 seems to have eliminated the major bugs. I think some of the Oracle push to the self-managing, self-tuning, self-burping database resulted in some real crapola code getting into the RDBMS -- a case of trying to cram in too many new features in too short a time.
There are other possibilities such as a table being moved after the index was built. But I suppose you would know about those.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri May 21 2004 - 10:38:06 CDT
 |
 |