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

Home -> Community -> Usenet -> c.d.o.server -> ORA-08102: Indexkey not found, obj# 18834, dba 8564021 (2)

ORA-08102: Indexkey not found, obj# 18834, dba 8564021 (2)

From: Michael Kurz <Michael.Kurz_at_c-plan.com>
Date: Wed, 4 Aug 1999 12:55:47 +0200
Message-ID: <7o963j$5m3$1@news.okay.net>


Hello

I get this Message if I make a delete.
The delete works on some Records and on some I get this Message.

ORA-08102: Indexkey not found, obj# 18834, dba 8564021 (2)

What can I do ????

I Rebuild my indexes but didn't help.
It's obscure because the select on the same record works.

DELETE FROM ALB_EIGENTUEMER WHERE BUCH_KENNZEICHEN='0000-0000-5046601'
>>ORA-08102: Indexschlüssel nicht gefunden, obj# 18834, dba 8564021 (2)

DELETE FROM ALB_EIGENTUEMER WHERE FID=522
>>ORA-08102: Indexschlüssel nicht gefunden, obj# 18834, dba 8564021 (2)

The select on the same record works !!!! SELECT * FROM ALB_EIGENTUEMER WHERE BUCH_KENNZEICHEN='0000-0000-5046601' Thanx for an answer
Micha Received on Wed Aug 04 1999 - 05:55:47 CDT

Original text of this message

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