Re: How to drop DML queue in context server?

Actually Rod,
it is exactly how Oracle recomends that you do it. Even to the point of truncating those tables. If you submitted this job as a batch job through the Context Admin utility you also need to execute dbms_job.delete to delete the job otherwise it will forever stay in the job cue and will never stop running.

--kamie

Rod Stewart wrote in message <74erpp$lf$1_at_platinum.sge.net>...
>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 Tue Dec 08 1998 - 00:00:00 CST