ORA-24011: cannot drop QUEUE, string should be stopped first



ORA-24011: cannot drop QUEUE, string should be stopped first..

Answer / guest

Cause: The queue has not been stopped i.e. either enqueue or
dequeue is still enabled.

Action: Stop the queue first using the STOP_QUEUE command
and disable it from both enqueueing and dequeueing.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14634: Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table

1 Answers  


ORA-29890: specified primary operator does not have an index context

1 Answers  


ORA-16130: supplemental log information is missing from log stream

1 Answers  


ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword

1 Answers  


ORA-34489: (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.

1 Answers  






TNS-01049: %s (string) has string service handler(s)

1 Answers  


LFI-01002: Unable to read line from file.

1 Answers  


ORA-16708: The state supplied to resource guard is invalid.

1 Answers  


ORA-00257: archiver error. Connect internal only, until freed.

1 Answers  


QSM-02148: many to many subquery joins require 9.0 compatibility or higher

1 Answers  


ORA-12160: TNS:internal error: Bad error number

1 Answers  


ORA-03128: connection is in blocking mode

1 Answers  


Categories