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!

Oracle index or partition is in unusable state

2806078Apr 10 2017 — edited Apr 11 2017

Hello,

I have an Oracle 11g R2 online dg (not clustered) and i've receving the following error:

ORA-01502: index 'xxx.my_index_name' or partition of such index is in unusable state

Now this was true for one of the partitions so i rebuilt it:

alter index xxx.my_index_name rebuild partition P_somedate;

But i'm stil receiving the error message and when i do a:

select * from dba_ind_partitions where status = 'UNUSABLE'; no rows are returned?

I have noticed because the db is quite active that when this does happen peformance suffers a great deal.

What am i doing wrong, is this a timing issue or something or there another query that can verify these partitions are ok?

thank you.

This post has been answered by Mustafa KALAYCI on Apr 10 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2017
Added on Apr 10 2017
12 comments
5,706 views