Re: Context query results in empty set

Thanks alot Joel.

Its working now.

regards/Ritu

In article <37383369.7981276_at_newshost.us.oracle.com>,   jkallman_at_us.oracle.com wrote:
> On Tue, 11 May 1999 12:01:20 GMT, ritub_at_my-dejanews.com wrote:
>
> >Hi everybody
> >
> >I have done following to run context query:
> >
> >step1->ctxsrv80 -user ctxsys/ctxsys -personality DQ
> >step2->exec ctx_ddl.create_policy('con_docs','erpdev.contable.text');
> >step3->exec ctx_ddl.create_index('ctx_docs');
> >step4->select * from contable where contains(text,'test',0)>0
> >
> >but this results in no rows selected though the word 'test' occurs so
> >many times in the document.
>
> Your rows are not indexed. The easiest solution to your problem would
> be to include "M" personality when starting up your ConText server (as
> in "ctxsrv80 -user ctxsys/ctxsys -personality DQM".
>
> From the Oracle8 ConText Cartridge Administrator's Guide:
>
> "The DML personality enables a ConText server to automatically update
> the text index for a table when changes to the table are made that
> require the text index to be update. Such changes include inserting
> new documents, updating existing documents, and deleting existing
> documents."
>
> >
> >Somebody please help.
> >regards/ Ritu
> >
> >
> >--== Sent via Deja.com http://www.deja.com/ ==--
> >---Share what you know. Learn what you don't.---
>
> Thanks!
>
> Joel
>
> Joel R. Kallman
> Oracle Service Industries
> Columbus, OH http://govt.us.oracle.com
> jkallman@us.oracle.com http://www.oracle.com
>
> ----
> The statements and opinions expressed here are my own
> and do not necessarily represent those of Oracle Corporation.
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 11 1999 - 22:40:56 CDT