CTX_DDL.OPTIMIZE_INDEX MERGE Fails With ORA-22165
(Doc ID 2467610.1)
Last updated on NOVEMBER 11, 2019
Applies to:Oracle Text - Version 188.8.131.52 and later
Information in this document applies to any platform.
exec ctx_ddl.optimize_index(idx_name => '<index name>', optlevel => 'MERGE');
fails with the following error stack
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in dreogHandleTokenErrors
ORA-22165: given index  must be in the range of  to 
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1161
ORA-06512: at line 2
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document