ORA-24011: cannot drop QUEUE, string should be stopped first
- 1 Answers
- 2881 Views
- I also Faced
- E-Mail Answers
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-25500: database is not open
ORA-07258: spdcr: fork error, unable to create process.
ORA-00017: session requested to set trace event
ORA-02834: Server unable to open file
ORA-07287: sksagdi: unsupported device for log archiving.
ORA-19641: backup datafile checkpoint is SCN string time string
ORA-06129: NETTCP: unable to transfer socket ownership to ORASRV
ORA-24099: operation not allowed for 8.0 compatible queues
PCC-02328: undefined struct member
ORA-12809: cannot set string_INSTANCES when mounted in exclusive mode
PLS-00305: previous use of 'string' (at line string) conflicts with this use
ORA-31471: invalid OBJECT_ID value
Oracle Errors 
