Underscore In Search String Does Not Work With Oracle Text Search (Doc ID 755008.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.2 and later
Information in this document applies to any platform.

Symptoms

While searching UCM, underscore does not work as expected with Oracle Text Search (11g) indexing.

' _ ' in Search string such as dDocAccount contains 'TEST_' it does not return the expected results.  Removing the '_' does return the expected results.

Some or all of the following errors will be seen in the Content Server logs when this issue occurs:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms