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

Hello Jonathan
thanx for your help.

object 18834 was and Index of ALB_EIGENTUEMER (but not that of the Field from the where clause)

I found help by the Oracle Hotline.

I have to drop the index and recreate it, then it works.

The Problem still is, that if I Import data with the SQL-Loader the index is corrupt again.

The hotline said that the problem is solved with Version 8i.

Bye
Micha

Jonathan Lewis schrieb in Nachricht
<933766405.11603.0.nnrp-10.9e984b29_at_news.demon.co.uk>...
>
>Do you have an ON DELETE CASCADE trigger ? Is the error
>perhaps on a child table which is being cleared, rather than
>the parent index ?
>
>Check whether object 18834 is the ALB_EIGENTUEMER table.
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>Michael Kurz wrote in message <7o963j$5m3$1_at_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 - 18:07:37 CDT