OraFAQ Forum: Text & interMedia

Home » Server Options » Text & interMedia » Force Search?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Force Search? [message #177612]

Thu, 15 June 2006 15:00

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

Report message to a moderator