My Oracle Support Banner

THE FND_LOBS_CTX INDEX IS MISSING FROM THE DATABASE (Doc ID 2363383.1)

Last updated on MARCH 01, 2024

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Oracle database 12.1.0.2.0 => Production

User unable to make file attachments in oracle Form. its failing with

java.sql.SQLException: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexInsert
ORA-20000: Oracle Text error:
DRG-10607: index meta data is not ready yet for queuing DML
ORA-00068: invalid value 1500000000 for parameter _kgl_large_heap_assert_threshold, must be between 0 and 0
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 756

Cause

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
Symptoms
Cause
Solution
References


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