Apologies for not replying immediately. Was tied up with something else. Searched again on metalink advanced option for <quote> 8.1.7.2 IOT [25012] </quote> with MATCH all (AND(++)) option .
Click on Doc ID: Note:165461.1 (ie) option 4 8.1.7.X Patch Sets - List of Bug Fixes by Problem Type Search for 25012 in that and you should get <quote> Bug 1527982 Abstract: ORA-600 [25012] Bitmap index<->table mismatch after UPDATE of PARTITION KEY moves rows Details: If a partitioned table has LOCAL BITMAP INDEXES and the partition key is updated such that the row moves to a different partition then the bitmap index is not updated correctly causing subsequent errors (eg: ORA-600 [25012]) when accessing table data via the bitmap index. This bug is generic and reported on 8.1.6.2. It has been fixed in 9i and 8.1.7.2.0. A few backports to 8.1.6.3.0 are available. To reproduce: create table bmi_test (id number(5), val varchar(5)) partition by range (id) (partition low values less than (100) tablespace users, partition high values less than (200) tablespace users) enable row movement; insert into bmi_test values (1,'red'); commit; create bitmap index bmi_test_idx on bmi_test (val) local; update bmi_test set id=100 where id=1; commit; analyze table bmi_test validate structure cascade; The last command should result in Ora-1499. Ensure that you have run the utlvalid.sql from your $ORACLE_HOME/rdbms/admin directory or else you would get ORA-14508: "specified VALIDATE INTO table not found" instead of an ORA-1499. <quote> HTH GovindanK > hi, GovindanK: > I searched metalink and cannot find note:287936.999 you mentioned. > And I did not move the IOT index segment and overflow segment online. > I > did those operation during system outage. > Thanks. > > Regards > zhu chao > msn:[EMAIL PROTECTED] > www.cnoug.org > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, September 05, 2003 9:54 AM > > >> Take a look at the Metalink Note:125149.1 >> ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index >> As per the note it affects 8.1.(5/6/7).x >> >> It has the relevant info. >> >> Also take a look at the Docid: 287936.999. >> >> HTH >> GovindanK >> >> > Sun solaris 8/oracle 8.1.7.2 64bit. >> > >> > After some database defrag(via alter table xxx move and alter index >> xxx >> > rebuild), I got 600-25012 from my delete session and alert file. >> > >> > >> > SQL> DELETE FROM EOI_PDTLIST WHERE ROWNUM=1; >> > DELETE FROM EOI_PDTLIST WHERE ROWNUM=1 >> > * >> > ERROR at line 1: >> > ORA-00600: internal error code, arguments: [25012], [15], [32], [], >> [], >> > [], [], >> > [] >> > >> > This is index organized table with overflow segment. >> > Maybe I foget to move that overflow segment, after move overflow >> segment > , >> > delete is ok. >> > >> > But according to metalink ,maybe there is data corruption. So I ask >> here >> > if friends in this list has also hit this nasty problem too. >> > >> > >> > Fri Sep 5 04:29:58 2003 >> > Errors in file >> /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: >> > ORA-00600: internal error code, arguments: [25012], [15], [32], [], >> [], >> > [], [], [] >> > Fri Sep 5 04:30:33 2003 >> > Errors in file >> /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: >> > ORA-00600: internal error code, arguments: [25012], [15], [32], [], >> [], >> > [], [], [] >> > Fri Sep 5 04:36:08 2003 >> > >> > I dbved the datafiles of that tablespace , nothing wrong. >> > My account in metalink cannot open Itar now:( >> > Thanks >> > >> > Zhu Chao >> > www.cnoug.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
