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
