Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INDEX GETTING UNUSABLE

jjkMay 29 2009 — edited May 29 2009
Hello everybody,
I'm using Oracle 9i and I'm getting below error when I execute a anonymous block which runs through the cursor and updates the table.

ORA-01502: index 'ASAP.PK_STATUS_NO' or partition of such index is in unusable state

select query on the same table is executing fine but seems that update is getting troubled. And the status number column is declared to be primary key

Can anyone tell me what and where the problem might be ???

regards,
Rossy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2009
Added on May 29 2009
3 comments
740 views