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-26688: missing key in LCR

1 Answers  


UDE-00016: 'string' parameter requires a value.

1 Answers  


SQL*Loader-00281: Warning: ROWS parameter ignored in parallel mode.

1 Answers  


ORA-13349: polygon boundary crosses itself

1 Answers  


ORA-38446: Error with embedded ADT "string" in the attribute set.

1 Answers  


QSM-00790: the workload string cannot be modified or changed because it is being used by task string

1 Answers  


ORA-24375: Cannot use V6 syntax when talking to a V8 server

1 Answers  


NNL-00851: Renames refused, name is not a leaf name: number

1 Answers  


ORA-28270: Malformed user nickname for password authenticated global user.

1 Answers  


ORA-38712: Corrupt flashback log record header: block string, offset string.

1 Answers  


ORA-31504: cannot alter or drop predefined change source

1 Answers  


AMD-00154: Cannot delete session object "string" in Workspace "string"

1 Answers  


Categories