报错内容:
ORA-29855: 执行ODCIINDEXCREATE 例行程序时出错
ORA-20000: Oracle Text错误:
DRG-10700: 首选项不存在:global_lexer
ORA-06512: 在"CTXSYS.DRUE", line 160
ORA-06512: 在"CTXSYS.TEXTINDEXMETHODS", line 364
解决方法:
1.查出问题索引并DROP:
select * from sys.all_indexes t where t.owner='CTXSYS' and t.index_type='DOMAIN';
select owner,index_namefrom all_indexes where domidx_status!='VALID' or domidx_opstatus!='VALID';
drop index INDEXNAME;
2.手动重建所有问题索引:
create index INDEX_ID on TABLENAME(FIELDNAME) indextype is ctxsys.context