Re: Oracle text lookup...

From: <dcosta_at_lnec.pt>
Date: Tue, 7 Nov 2006 23:48:43 -0000 (WET)
Message-ID: <9402.83.132.142.96.1162943323.squirrel@lepus.lnec.pt>

Hello !

I Hoppe the following example will help You. The instruction for creating the index may be the cause for Your problem.

---

drop table ORG_NAME;
create table ORG_NAME (NAME varchar2(12));

drop index ORG_NAME_NAME;
create index ORG_NAME_NAME on ORG_NAME(NAME) INDEXTYPE IS ctxsys.context;

insert into ORG_NAME values('my ward');
insert into ORG_NAME values('your ward');
insert into ORG_NAME values('backward');
insert into ORG_NAME values('frontward');
insert into ORG_NAME values('forward');

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



SQL> select   NAME
2    from     ORG_NAME

3 where contains(NAME, '% ward') > 0;

NAME

---

my ward
your ward

regards
Dias Costa

> 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
>
>
>

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

Received on Tue Nov 07 2006 - 17:48:43 CST