Oracle text lookup...

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 7 Nov 2006 14:44:28 -0800 (PST)
Message-ID: <20061107224428.6451.qmail@web38909.mail.mud.yahoo.com>

Fellow Oracle types...

So, I have a query like this:

select * from ORG_NAME where contains(NAME, '% ward')
> 0

*
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

What I want is to be able to bring back records like:

My ward
your ward

and not bring back records like

backward
frontward

Any ideas on how I do this. Looking at Metalink and Google it looks like the % is just expanding everything...

Robert G. Freeman
Author:
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Oracle Replication (Rampant Tech Press)
Mastering Oracle8i (Sybex)
Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>) Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 07 2006 - 16:44:28 CST