Optimizing Search Index Fails With DRG-11341: Index Optimization Failed For One Or More Tokens (Doc ID 2961303.1)

Last updated on AUGUST 09, 2023

Applies to:

Symptoms

When input row has a JSON field with a TIMESTAMP value [stored in $ST], OPTIMIZE in FULL mode fails with "DRG-50857: oracle error in drextmain".


SQL> CREATE SEARCH INDEX T5_INDEX ON T5 ("json")
 2  FOR JSON
 3  PARAMETERS ('MEMORY 400M')
 4  LOCAL (
 5  PARTITION p1_10,
 6  PARTITION p2_20,
 7  PARTITION p3_max);

Index created.

SQL>
SQL> begin
 2  ctx_ddl.optimize_index(idx_name => 'T5_INDEX', optlevel => 'FULL', part_name => 'p2_20');
 3  end;
 4  /
begin
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-11341: Index optimization failed for one or more tokens <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.CTX_DDL", line 1288
ORA-06512: at line 2

SQL> exec ctx_report.validate_index('T5_INDEX',part_name => 'p2_20');
BEGIN ctx_report.validate_index('T5_INDEX',part_name => 'p2_20'); END;

*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-00100: internal error, arguments : [50402],[drft.c],[10481],[],[]
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.CTX_REPORT", line 888
ORA-06512: at line 1

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.