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)
There is a syntax error in the command issued.
Re-issue the command with correct syntax. Make sure that the name of the queue to be deleted is correctly specified.
The syntax for the command is as follows:
sp_ctrl (alvsupu16:5438)> help delete queue
Delete an unused queue
Usage: delete capture queue for datasrc [on host]
Usage: delete export queue quename [on host]
Usage: delete post queue quename for datasrc-datadst [cleartrans] [on host]
Delete an unused export process
Usage: delete export process to host [queue quename] [on host]
Since there are many options in the command and the syntax also involved punctuations like datasrc-datadst, there are many pitfalls which can result in above errors.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center