Ora-29861: domain index marked as loading/failed/unusable

Ora-29861: The domain index is marked as loading/failed/unusable this error is: this is a problem with the table's InterMedia index, the index is either not properly established, or a synchronization failure causes its status to be abnormal. You can only query the data and cannot change it. First, find the index: Select idx_name, idx_status from ctxsys. ctx_indexes; Then synchronize the index or Force Delete it: Rebuilding: Alter index myindex rebuild online parameters ('sync '); Delete: drop index myindex force;

Reprinted from: http://hi.baidu.com/zpjava/blog/item/0d17d7ddf69aee315882dd7c.html