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

NNO-00073: loading server config from region database

1 Answers  


ORA-06775: TLI Driver: error reading break mode

1 Answers  


SQL*Loader-00102: Invalid control file name on command line

1 Answers  


ORA-36706: (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  






KUP-04104: zoned decimal field has bad values for string

1 Answers  


RMAN-06911: only one PARALLEL or NOPARALLEL clause may be specified

1 Answers  


NNL-00501: set|show log_stats_interval [<seconds>] [<server_list>] : set|show the server's statistic counter logging interval

1 Answers  


ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher

1 Answers  


ORA-24810: attempting to write more data than indicated

1 Answers  


DRG-11403: primary key value too long

1 Answers  


ORA-28540: internal result set error

1 Answers  


Categories