The delete queue command results in error “Cop: delete queue failed: que_NOEXIST: Queue does not exist” (4301715)

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.