Oracle Text : Using Context Contains Search On Commas And Dots
(Doc ID 807749.1)
Last updated on JUNE 21, 2022
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.
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 |