Oracle Text Error when "FUZZY"is used

[Prabha Dhandapani]

Hi all,
I have a query like this:

SELECT 
score(1),
ASSOC_WORD_ROOT, 
ASSOC_WORD_ALTERNATE 
FROM 
ASSOC_WORD 
WHERE 
CONTAINS(ASSOC_WORD_ALTERNATE,'fuzzy(LORATADINE,60,60,weight)', 1) > 0 
order by score(1) desc
/

when i run this query, i get the following error:
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
I am a Java Programmer and want to use this query in my code...I browsed the net and found that this is realted to the index of the table...Can sombody tell me as to what to be done inorder to create that particular index...I want to do this today and get some "Appreciation"...Please help me!
Many thanks in advance,
Prabha

[Giovanni Azua]

Hello Prabha,

The error tells you exactly what you need
to do - create the TEXT index - e.g:

create index IDXC_ASSOC_WORD_ALTERNATE on ASSOC_WORD(ASSOC_WORD_ALTERNATE) indextype is ctxsys.context
/

Then you can start using the contains operator
with the column.

But this assumes you have Oracle TEXT installed
properly in your instance and the proper grant
has been granted to your schema: CTX_APP.

To setup Oracle TEXT follow the steps from:

http://www.orafaq.com/faqctx.htm

HTH,
Regards,
Giovanni