在Oracle中，对于错误“ORA-29861: domain index。。。”，该如何解决？

 有关该错误，官方文档的解释为：

29861, 00000, "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.

// *Action: Wait if the specified index is marked LOADING

//          Drop the specified index if it is marked FAILED

//          Drop or rebuild the specified index if it is marked UNUSABLE.

由此可见，解决办法应该是对全文索引进行重建或删除。查询全文索引的状态：

SELECT INDEX_NAME,

       INDEX_TYPE,

       STATUS,

       DOMIDX_STATUS,

       DOMIDX_OPSTATUS

FROM   USER_INDEXES

WHERE  INDEX_TYPE = 'DOMAIN'

AND    TABLE_NAME='XB_LHR_TAB'

AND    (DOMIDX_STATUS <> 'VALID' OR DOMIDX_OPSTATUS <> 'VALID');

同步索引或者强制删除索引：

重建：ALTER INDEX IDX_NAME_LHR REBUILD ONLINE PARAMETERS('SYNC');

删除：DROP INDEX IDX_NAME_LHR FORCE;