ORA-24012: cannot drop QUEUE_TABLE, some queues in string
have not been dropped



ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped..

Answer / guest

Cause: A queue exists in the queue table which has not been
dropped. All queues need to be dropped first.

Action: Drop all queues belonging to this queue table using
the drop_queue() command. Be sure to stop the queues
appropriately before dropping them. Alternately, use the
force option in drop_queuetable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-01076: Operational Status number

1 Answers  


SQL*Loader-00456: end of collection found after number elements when looking for number elements

1 Answers  


NNL-00898: Responses sent: number

1 Answers  


ORA-23304: malformed deferred rpc at arg string of string in call string, in tid string

1 Answers  


ORA-12645: Parameter does not exist.

1 Answers  






ORA-13150: failed to insert exception record

1 Answers  


ORA-13782: The specified user "string" does not exist.

1 Answers  


ORA-28526: invalid describe information returned to Heterogeneous Services

1 Answers  


RMAN-06060: WARNING: skipping datafile compromises tablespace string recoverability

1 Answers  


ORA-19623: file string is open

1 Answers  


TNS-01009: service [<listener_name>] : get the service information of the listener

1 Answers  


ORA-38479: creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed

1 Answers  


Categories