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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Used BMJIs in 9.2.0.4 [we get ORA-600 [12700]s]

RE: Used BMJIs in 9.2.0.4 [we get ORA-600 [12700]s]

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 07 Dec 2004 23:48:18 +0800
Message-Id: <6.1.2.0.0.20041207234537.0256aa78@pop.singnet.com.sg>

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-l
Received on Tue Dec 07 2004 - 10:00:47 CST

Original text of this message

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