My Oracle Support Banner

Oracle Text : Using Context Contains Search On Commas And Dots (Doc ID 807749.1)

Last updated on JANUARY 02, 2020

Applies to:

Oracle Text - Version 9.2.0.1 to 11.1.0.7 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 01-Oct-2013***


Symptoms

You want to make sure that commas "," and dots "." are part of your search, but you get error when you use them in the contains function.

This query:

select TITLE from TABLE_CONTEXT WHERE contains(TITLE,'SYSTEMS,%',1)
> 0
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms

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

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