Maximo Lexer Error
Usually you get lexer error after updating new schema for maximo ORA-20000: Oracle Text error: DRG-10700: preference does not exist: global_lexer ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112) To fix this issue which is mainly for missing global lexer or due to missing of indexes Step1:Running following queries for missing global lexer Note: Prior to running check proper access to database user call ctx_ddl.drop_preference('global_lexer'); call ctx_ddl.drop_preference('default_lexer'); call ctx_ddl.drop_preference('english_lexer'); call ctx_ddl.drop_preference('chinese_lexer'); call ctx_ddl.drop_preference('japanese_lexer'); call ctx_ddl.drop_preference('korean_lexer'); call ctx_ddl.drop_preference('german_lexer'); call ctx_ddl.drop_preference('dutch_lexer...