My Oracle Support Banner

ORA-600 [20084] from CONTAINS query (Doc ID 2660189.1)

Last updated on APRIL 16, 2020

Applies to:

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

Symptoms

Oracle Text CONTAINS query fails with an ORA-600 [20084]:

Error:  ORA-00600 [20084] [59350253] [0] [59350253] [0]

Error Stack: ORA-600[20084]
Main Stack:
  qerbtRop <- qersoFetchSimple <- qersoFetch <- qerbtFetch <- kdibr1sf <- qerbaFndOl
   <- qerbaStrmAnd <- qerbaFetch <- kdibr1sf <- qerbtFetch <- qertbFetchByRowID
    <- qerjoFetch <- qersoProcessULS <- qersoFetchSimple <- qersoFetch <- opifch2 <- kpoal8

Current SQL: SELECT text FROM quick WHERE CONTAINS ( text,'sat on the mat' ) > 0

Running the following query against the index's $K table returns rows:

 

Changes

 

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
Changes
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.