Re: How to drop DML queue in context server?
Date: 1998/12/08
Message-ID: <74k8p0$vt$1_at_winter.news.rcn.net>#1/1
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 CET