Re: Oracle text lookup...
- From: dcosta@xxxxxxx
- To: robertgfreeman@xxxxxxxxx
- Date: Tue, 7 Nov 2006 23:48:43 -0000 (WET)
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>)
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
