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-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers  


ORA-30556: functional index is defined on the column to be modified

1 Answers  


RMAN-06717: number of source files (string) and destination files (string) does not match

1 Answers  


DRG-11811: Multiple Choices

1 Answers  


TNS-12592: TNS:bad packet

1 Answers  


PCC-01513: FIPS warning: Unsupported datatype in line number of file string

1 Answers  


PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

1 Answers  


ORA-16712: the resource handle is invalid

1 Answers  


ORA-24812: character set conversion to or from UCS2 failed

1 Answers  


NID-00315: Operation already in progress, continuing

1 Answers  


ORA-16521: unable to create generic template id

1 Answers  


NZE-29191: OID connection information not set

1 Answers  


Categories