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.