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-600?

1 Answers   IBM,


NMP-00011: internal SNMP program interface error

1 Answers  


ORA-29911: null scan context returned by ODCIIndexStart() routine

1 Answers  


LSX-00344: namespace values "~1S" and "~2S" differ

1 Answers  


ORA-01086: savepoint 'string' never established

1 Answers  






DRG-51030: wildcard query expansion resulted in too many terms

1 Answers  


PLS-00403: expression 'string' cannot be used as an INTO-target of a SELECT/FETCH statement

1 Answers  


DRG-11404: no primary key value specified

1 Answers  


LFI-00002: Out of memory. string

1 Answers  


ORA-12336: cannot login to database (link name string)

1 Answers  


QSM-00515: operation cancelled by user

1 Answers  


PLS-01463: STDDEV is not a standard set function

1 Answers  


Categories