Wildcard query expansion resulted in too many terms.

Posted by PeteDaMeat on Stack Overflow See other posts from Stack Overflow or by PeteDaMeat
Published on 2010-03-31T15:06:36Z Indexed on 2010/04/01 2:23 UTC
Read the original article Hit count: 401

Filed under:

oracle10g

|

contains

|

wildcard

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?

© Stack Overflow or respective owner

Related posts about oracle10g

How to set _optimizer_search_limit and _optimizer_max_permutations in Oracle10g.

as seen on Server Fault - Search for 'Server Fault'
I am working on a product that must support both MSSQL and Oracle (10g and 11g). I have some very complex queries that seem to run without issue on MSSQL 2005/2008, but very, very slow with Oracle. The CPU on the oracle server skyrockets for long periods of time, and it seems like the optimizer… >>> More
Any suggestions on how to extract 6 million records from an oracle10g ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I just want to give you a little background Need to write a PL-SQL which will extract 6 million record joining different tables and create a file of that. Need more suggestions, specifically on how to fetch these many records. As fetching these million of records on a single go can be a highly resource… >>> More
How to write a optimized code to fetch 6 million records from Oracle10G database and write them on a

as seen on Stack Overflow - Search for 'Stack Overflow'
What to use in oracle 10G to extract 6 million records and create a flat file of it ? >>> More
how to know the names of other users in oracle10g?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys,i want to know how can we know the other users of oracle 10g on the same system. Is there any querry for that? thank you!!! >>> More
Where is the C precompiler for Oracle10g located?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for a newer version of the Pro*C/C++ to upgrade my procui.exe 9.0.1.1.1. I downloaded the 10g client disk and when install I have the following options: instant client administrator runtime custom I dont seem to able to find the actual program other than just getting some… >>> More

Related posts about contains

Sorting List which has object that contains two string members that contains numbers

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to know the best solution for this my case here is that i am taking values from Excel sheet and pushing them to database field, sometimes that field might contain some strings (thats why I cant make my object members int / double) In my class below size is the variable responsible for showing… >>> More
Testing if a list contains another list with Python

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I test if a list contains another list. Say there was a function called contains: contains([1,2], [-1, 0, 1, 2]) # Returns [2, 3] (contains returns [start, end]) contains([1,3], [-1, 0, 1, 2]) # Returns False contains([1, 2], [[1, 2], 3) # Returns False contains([[1, 2]], [[1, 2], 3]) # Returns… >>> More
Full Text Index Queries using CONTAINS and CONTAINSTABLE

as seen on Internet.com - Search for 'Internet.com'
Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on the remaining two constructs, CONTAINS and CONTAINSTABLE. >>> More
Search in a List<DataRow>?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a List which I create from a DataTabe which only has one column in it. Lets say the column is called MyColumn. Each element in the list is an object array containing my columns, in this case, only one (MyColumn). Whats the most elegant way to check if that object array contains a certain… >>> More
nhibernate activerecord linq Contains problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am having problems with the following query in Castle ActiveRecord 2.12: var q = from o in SodisceFMClientVAR.Queryable where taxnos2.Contains(o.TaxFileNo) select o; taxNos2 is an array of strings. When run I get an exception: + InnerException {"Index was out of… >>> More