PL/SQL error

610 pts.
Tags:
Oracle development
Oracle error messages
PL/SQL
PL/SQL error messages
Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

Answer Wiki

Thanks. We'll let you know when a new response is added.

If the corruption is in the index, then rebuilding the index won’t help, because it will rebuild from itself with the corrupt information. If that is the case you will need to drop the index and create it again.

If re-creating the index doesn’t solve the problem, then the corruption may be in the table.

If the number of different values in the index is small, you could issue a SELECT statement against the table to get the indexed column, forcing a full table scan.

For example, if the indexed column is YEAR. The statement should be something like this:

<pre>SELECT /*+ FULL */ year from table_X where year not in (2000,2001,2002,2003,2004,2005,2006,2007,2008);</pre>

Being 2000-2008 the only values that exists in the index.

If this select returns some rows, those are the corrupted ones, and you will need to drop any index containing the column, delete or update the table with the appropriate values for this rows, and then create the necessary indexes again.

As for the possible causes, it could be a number of things:

- memory problems
- system crashes
- disk errors
- it could also be caused by disk repair utilities

Please tell us if you solve the problem.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Inprise
    Hi, Rebuilding index and free up some tablespace helped me to resolve this issue. thanks !!!
    610 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following