| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to find INDEX CORRUPTION ???
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.
dwilliams_at_lifetouch.com
-----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: jprem_at_kssnet.co.jp
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Wed Apr 02 2003 - 08:18:52 CST
 |
 |