Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Text, wildcards AND escape characters help
That doesn't work...
SQL> select count(projectid) from project
2 where contains(objectives, '{agent}%', 1) >0;
select count(projectid) from project
*
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 termsReceived on Tue Sep 20 2005 - 12:16:00 CDT