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

SELECT idx_name,idx_status FROM   ctxsys.ctx_indexesWHERE  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 droppedSQL> create index PURCHASE_PART_TIX on PURCHASE_PART_TAB (TEXT_ID$) indextype is CTXSYS.CONTEXT;  Index created