ORA-24011: cannot drop QUEUE, string should be stopped first
Answer / guest
Cause: The queue has not been stopped i.e. either enqueue or
dequeue is still enabled.
Action: Stop the queue first using the STOP_QUEUE command
and disable it from both enqueueing and dequeueing.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters
NZE-29247: an unopen toolkit object was used before it was opened
ORA-29811: missing STATISTICS keyword
ORA-25351: transaction is currently in use
ORA-25294: Queue string has a buffer
ORA-03122: attempt to close ORACLE-side window on user side
ORA-00261: log string of thread string is being archived or modified
IMP-00015: following statement failed because the object already exists:
ORA-16234: restarting to reset Logical Standby apply
ORA-03242: Tablespace migration retried 500 times
give full details of this ORA-12988: cannot drop column from table owned by SYS
RMAN-20503: DELETE cannot delete expired objects - run CROSSCHECK or DELETE EXPIRED