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-27300: OS system dependent operation:string failed with status: string

1 Answers  


ORA-06001: NETASY: port set-up failure

1 Answers  


NZE-29194: no CRL found in cache

1 Answers  


PLS-00634: type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE

1 Answers  


ORA-24023: Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]

1 Answers  






DRG-51025: an invalid character was passed to the stemmer

1 Answers  


NNL-00579: _scan: find objects/records matching the given types

1 Answers  


ORA-19599: block number string is corrupt in string string

1 Answers  


ORA-07220: slspool: wait error.

1 Answers  


ORA-29359: invalid method name string specified for resource plan string

1 Answers  


ORA-02840: Open of log file by client failed

1 Answers  


IMG-00823: boundary queue pop failed

1 Answers  


Categories