Re: How to drop DML queue in context server?

From: Rod Stewart <rod.stewart_at_afp.gov.au>
Date: 1998/12/07
Message-ID: <74erpp$lf$1@platinum.sge.net>#1/1

This is probably NOT the way Oracle recommend you do this, but:

Log in as ctxsys. Delete the contents from the drq_pending table and commit. You may also need to delete the contents of the drq_waiting table as well. You should then check to see if there is anything in the services queue (ctx_svcq) and attempt to clean that out as well using ctx_svc.clear_error (svcno);

Hope this helps

Rod

Ant wrote in message <74aum8$geh_at_eng-ser1.erg.cuhk.edu.hk>...
>Hi
>I am new to the use of context server.
>I re-indexed some text column using ctx_dml_reindex but server getting on
>running(hard disk continuouly busy)
>for an hour. I stopped the server. Since then the reindex process was
always
>pending since NOV 16.
>How can drop DML index process queue?
>
>
>Thanks
>Antony Ma
>
>
Received on Mon Dec 07 1998 - 00:00:00 CST