Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Used BMJIs in 9.2.0.4 [we get ORA-600 [12700]s]
On 9.2.0.4 64-Bit Solaris.
Yes, we have had corrupt indexes -- detected either when the user reports
ORA-600 [12700] {also logged
in the alert.log} or when we run an ANALYZE TABLE ... VALIDATE STRUCTURE
CASCADE
We are now investigating recreating the BMJIs periodically. Another
option, as recommended
by Oracle was to upgrade to 9.2.0.5
However, you state that there are some bugs with ASSM and BMIs in 9.2.0.5
? Can you provide
some bug numbers ?
Hemant
At 12:23 AM Friday, Subbiah, Nagarajan wrote:
>Any index corruption bug associated with this?
>
>If you use the ASSM and you are on 9.2.0.5, There are some known bugs with
>bitmap indexes.
>
>-----Original Message-----
>From: Hemant K Chitale [mailto:hkchital_at_singnet.com.sg]
>Sent: Thursday, December 02, 2004 11:01 AM
>To: oracle-l_at_freelists.org
>Subject: Used BMJIs in 9.2.0.4 [we get ORA-600 [12700]s]
>
>
>
>9.2.0.4 64-bit on Solaris 8
>
>Anyone used BitMap Join Indexes successfully ?
>
>We keep getting occassional ORA-600 [12700] {Index entry invalid} and have
>to rebuild the Indexes.
>The application schema has been designed by a vendor.
>
>
>
>Hemant K Chitale
>http://web.singnet.com.sg/~hkchital
>
>
>
>
>--
>http://www.freelists.org/webpage/oracle-l
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 07 2004 - 10:00:47 CST
![]() |
![]() |