| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Context query results in empty set
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
 |
 |