Tuesday 17 April 2012

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

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

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.

No comments:

Post a Comment