Tuesday, February 10, 2015

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

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

Cause: 

An attempt has been made to access a domain index that is being built or is marked failed by an unsuccessful DDL or is marked unusable by a DDL operation.

Solution:

alter index indexname rebuild; 

No comments:

Post a Comment