The following error are observed when attempting to delete a queue using the command “delete queue <queue_name>:
sp_ctrl (alvsupu16:5438)> delete post queue queue1 for o.ORA11GR2
cnc_delete_queue() Queue error - user/queue was not deleted; Check event_log for details.
The event log shows the following error:
sp_ctrl (alvsupu16:5438)> show log reverse
Error 2017-05-11 16:54:41.482319 22633 1 Cop: delete queue failed: que_INUSE: Que is already open [module cop]
Notice 2017-05-11 16:54:41.481355 28267 1 User command: oracle delete queue queue1:P for o.ORA11GR2-o.ORA11GR2 (from alvsupu16)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center