Wildcard query expansion resulted in too many terms.

Question

I am receiving a "wildcard query expansion resulted in too many terms" error when executing a query similar to the following:

SELECT * FROM table_a WHERE contains(clob_field, '%a%') > 0;

Does anyone know a workaround/solution to this problem?

Answer 1

According to this, you may need to increase the wildcard_maxterms parameter, or take further steps. See the link for details (I'm not an expert in Oracle Text though).