Friday, February 4, 2011

ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Today I encountered this ORA- error when trying to update a table:

ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE


According to this post, I resolved the error by rebuild the "FAILED" index after identifying which index was corrupt: 
select index_name,index_type,status,domidx_status,domidx_opstatus from user_indexes where index_type = 'DOMAIN' and (domidx_status <> 'VALID' or domidx_opstatus <> 'VALID');

2 alter index &indexname rebuild; 

Labels: ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home