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