Prem
   It is possible that you have some corruption in your table. My advice
would be to immediately export the table. If there is any corruption on the
table, this will find it. If no corruption is reported, you will have a good
copy of your table to proceed with. If corruption is found, then I believe
Metalink has some notes on this.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-----Original Message-----
Sent: Wednesday, April 02, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L


Guys,

I faced this error in an instsance of 8.1.6/win2k.

Errors in file E:\ORACLE\ADMIN\ORA816\UDUMP\ORA00696.TRC:
ORA-00600: Internal Error
:[13013],[5001],[22211],[134225362],[15],[134225362],
[1],[]

but this morning i dropped an existing index ( on 3 columns together ).
and created a bitmap index on FROMMEMNO ( a column in MSG_HISTORY table ).
when i delete a row from MSG_HISTORY table now , i get this ORA 600 error.

if i drop the index , DELETE works fine .
if i create a index , it results in ORA 600.

metalink says that it might be because of ondex corruption.
how do i find index corruption ?
does it mean that even a new index on this particular column will be a
corrupted 
index ?

Help me guys.

TIA.
Jp.


 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: DENNIS WILLIAMS
  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).

Reply via email to