ORA-24012: cannot drop QUEUE_TABLE, some queues in string
have not been dropped
- 1 Answers
- 5199 Views
- I also Faced
- E-Mail Answers
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 |
LFI-00147: File string.string does not exist
NCR-02009: NCRF: Unable to open trace file
DRG-11445: rowid value is invalid: string
NNL-00895: Requests refused, processing disabled: number
PLS-00500: invalid operator binding
DRG-11857: Server Timed Out
ORA-12656: Cryptographic checksum mismatch
ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings
ORA-01514: error in log specification: no such log
ORA-00078: cannot dump variables by name
ORA-10631: SHRINK clause should not be specified for this object
SQL*Loader-00265: Unable to get default character set name.
Oracle Errors 
