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

ORA-12984: cannot drop partitioning column

1 Answers  


EXP-00059: error converting an object type's identifier to characters

1 Answers  


ORA-02839: Sync of blocks to disk failed.

1 Answers  


ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches

1 Answers  


ORA-02272: constrained column cannot be of LONG datatype

1 Answers  






ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


PLS-01503: The expression in a SET clause must not include a set function

1 Answers  


PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 Answers  


PLS-00250: Incorrect Usage of string in parameters clause.

1 Answers  


ORA-24357: internal error while converting from to OCIDate.

1 Answers  


NZE-28867: Integer value is too big.

1 Answers  


ORA-29336: Internal error [string] [string] from DBMS_PLUGTS

1 Answers  


Categories