ORA - 08102 : index key not found [message #53739] |
Tue, 08 October 2002 21:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ramesh
Messages: 123 Registered: August 2000
|
Senior Member |
|
|
hi
when i am updating a record thru front-end (D2K form 6.0) then the following error is coming
ORA-08102: index key not found, obj# 5569, dba 22585769 (2)
can u tell me what is the posible reason of it.
|
|
|
Re: ORA - 08102 : index key not found [message #53740 is a reply to message #53739] |
Tue, 08 October 2002 22:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
Seems that your index got corrupted.
Check the trace file which was generated on the db instance for more information. I believe the obj# is the object_id from dba_objects, so if you query on object_id=5569 you can find the object_name, owner and object_type.
The index rebuilding will not fix the problem, so you better drop it and re-create it from scratch.
Hope that helps,
clio_usa
OCP DBA
Check our Web site
|
|
|