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: chao_ping
> > 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).
> >
>
> --
> 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).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: zhu chao
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).
