How to Optimize a Metadata Field for WebCenter Content (WCC) OracleTextSearch (OTS)? (Doc ID 1395572.1)

intradoc.common.ServiceException: !csOracleTextErrorExecutingQuery,(((({JSP} WITHIN dSecurityGroup)) or (({Operational} WITHIN dSecurityGroup)) or (({Public} WITHIN dSecurityGroup)) or (({WebContent} WITHIN dSecurityGroup))) and ((((ASSETS#HS#CN%) WITHIN dDocAccount)) or (((ASSETS#CM#RT#LIC%) WITHIN dDocAccount)) or (({idcnull} WITHIN dDocAccount)) or (((public%) WITHIN dDocAccount)) or (((CEDEM%) WITHIN dDocAccount)) or (((EHPLANDN%) WITHIN dDocAccount)) or (((EHSTRAT%) WITHIN dDocAccount)) or (((ORG#R%) WITHIN dDocAccount))))!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms

ORA-06512: at "CTXSYS.DRUE"\, line 160
ORA-06512: at "CTXSYS.CTX_QUERY"\, line 788
ORA-06512: at "UCM.CONTENT_SEARCH"\, line 123
ORA-06512: at line 1

at intradoc.server.SearchManager.handleSearchStatusMessage(SearchManager.java:315)
at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1347)
at intradoc.server.SearchService.doLocalSearch(SearchService.java:1049)
at intradoc.server.SearchService.getSearchResults(SearchService.java:531)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 

DRG-12245 SDATA operator not compatible with the sdata section