Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-19030: Method invalid for non-schema based XML Documents.

1 Answers  


QSM-00752: the parameter string contains an invalid combination of options string

1 Answers  


RMAN-06911: only one PARALLEL or NOPARALLEL clause may be specified

1 Answers  


ORA-15123: ASM file name 'string' contains an invalid incarnation number

1 Answers  


NNO-00633: detected fatal delegation loop involving server "string"

1 Answers  






ORA-32628: invalid nesting of MODEL cell reference

1 Answers  


PCC-00027: Redeclared SQL Identifier "string" at line number in file string

1 Answers  


ORA-09882: sstasfre/sstasdel: shmctl error, unable to remove tas shm page

1 Answers  


ORA-19900: RESETLOGS must be specified after recovery to new incarnation

1 Answers  


ORA-13825: missing SQL statement text for create SQL profile

1 Answers  


ORA-25130: cannot modify primary key - primary key not defined for table

1 Answers  


ORA-17619: max number of processes using I/O slaves in a instance reached

1 Answers  






Categories