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