ORA-29861: 域索引标记为loading/failed/unusable

1. 以SYS登录数据库执行查询

SELECT idx_name,idx_status 
FROM   ctxsys.ctx_indexes
WHERE  idx_status <> 'INDEXED';
或
SELECT OWNER, INDEX_NAME
FROM   ALL_INDEXES
WHERE  DOMIDX_STATUS != 'VALID'
OR     DOMIDX_OPSTATUS != 'VALID';

2. 删除索引，重新创建

SQL> drop index PURCHASE_PART_TIX force;

Index dropped


SQL> create index PURCHASE_PART_TIX on PURCHASE_PART_TAB (TEXT_ID$) indextype is CTXSYS.CONTEXT;
  

Index created