user13780543 wrote:Even though the rows containing '%FARRO AL NAT%' and the rows containing '%FARRO AL NATU%' are the same, there are apparently more rows containing 'NAT%' than 'NATU%'. It is the expansion of the individual term that causes the error, not the whole search string.
In oracle Text with contains query , the search with the keyword '%FARRO AL NAT%' returns too many terms error but with an addition of character '%FARRO AL NATU%' produces the result. But the no. of records for both the search strings are same.
Could anyone explain, what is the exact issue here.
user13780543 wrote:Using AND won't make a difference, as it is still the expansion of the individual term that raises the error. However, you can change the wildcard_maxterms setting, but there are drawbacks. Please see the excerpt from the online documentation below regarding setting wildcard_maxterms.
Thanks for the reply,Barbara .
So, Will it work in such a way that it will get the results for all the individual terms in the search string and get the final result with the AND operation ?
So, if i need to get the result of the whole search term, will it be possible?