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

LPX-00657: Invalid output PI '~S'.

1 Answers  


TNS-00145: PUMPS value in INTCHG.ORA is too large.

1 Answers  


TNS-04203: Trace Assistant Usage ERROR: Invalid options

1 Answers  


ORA-09717: osnsui: maximum number of user interrupt handlers exceeded.

1 Answers  


ORA-23477: unable to alter propagation mode for object group "string"."string"

1 Answers  






ORA-06767: TLI Driver: alloc failed during release

1 Answers  


NNL-00550: flush [<server_list>] : flush one or more servers' cache(s)

1 Answers  


LSX-00232: invalid unsigned long "~S"

1 Answers  


PCB-00206: Cannot use N quoted literal in PL/SQL when NLS_LOCAL=YES

1 Answers  


ORA-36804: (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP.

1 Answers  


DRG-50608: unexpected end of data

1 Answers  


LFI-00101: Write failed, file cannot be written to.

1 Answers  


Categories