Last updated on FEBRUARY 08, 2017
Applies to:Oracle Text - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Apr-2013***
When exectuing query:
SELECT col1, col2
where CONTAINS(text, 'L.R%') > 0
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms
The problem is in the CONTAINS(text, 'L.R%')
If using 'L.RA%' or 'LR' then it works correctly.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms