Home » RDBMS Server » Server Administration » ORA - 08102 : index key not found
ORA - 08102 : index key not found [message #53739] Tue, 08 October 2002 21:27 Go to next message
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
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

Previous Topic: session memory under MTS configuration
Next Topic: about vb sql
Goto Forum:
  


Current Time: Thu Sep 19 17:51:06 CDT 2024