Home » Server Options » Text & interMedia » Force Search?
Force Search? [message #177612] Thu, 15 June 2006 15:00 Go to next message
qzheng2005
Messages: 4
Registered: July 2000
Location: VA
Junior Member
Folks,

I did following query:

SQL> select stname from test_mv where contains(stname, 'Hwy 109 S%', 1) >1;
select stname from test_mv where contains(stname, 'Hwy 109 S%', 1) >1
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms


SQL> select stname from test_mv where contains(stname, 'Hwy 109 N%', 1) >1;

STNAME
--------------------------------------------------------------------------------
Hwy 109 Nc S
Hwy 109 Nc N
Hwy 109 Nc
Hwy 109 N

SQL> select stname from test_mv where contains(stname, 'Hwy 109 S',1) > 1;

STNAME
--------------------------------------------------------------------------------
Hwy 109 S

SQL>

---------------

I do found in the index table, entries start with 'S' are over
10000 and entries start with 'N' are less than 4500. Is that the reason why I got error when search for 'Hwy 109 S%'?

Is there a way can let oracle text rise the threshold on this so that it won't complain "too many terms" when entries are less than 20000?

Thanks,
Qiang
Re: Force Search? [message #177622 is a reply to message #177612] Thu, 15 June 2006 16:53 Go to previous message
Barbara Boehmer
Messages: 7937
Registered: November 2002
Location: California, USA
Senior Member
As far as I know, you will just have to provide more specific criteria to limit the results.
Previous Topic: weird way Oracle text index gets created
Next Topic: Listing top terms in a thesaurus
Goto Forum:
  


Current Time: Wed Jul 30 07:03:54 CDT 2014

Total time taken to generate the page: 0.11891 seconds