ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a
8.0 compatible multiple consumer queue
- 1 Answers
- 2420 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The CREATE_QUEUE or ALTER_QUEUE command was issued
with a non-zero RETRY_DELAY and a QUEUE_TABLE that was
created for multiple consumers and with COMPATIBLE parameter
set to '8.0'.
Action: Either set the RETRY_DELAY to zero or upgrade the
queue table to 8.1 compatible using the
DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
PLS-01467: The value list of the IN predicate, if not a subquery, must contain only value_specifications
RMAN-20031: resync not started
ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
ORA-36630: (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.
PLS-00140: duplicate external LIBRARY specification in subprogram expression
ORA-19002: Missing XMLSchema URL
QSM-02137: agg(expr) requires correspondng STDDEV(expr) function
ORA-01341: LogMiner out-of-memory
PCC-01301: Your Pro*PL/I authorization is about to expire
EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace
TNS-00512: Address already in use
LFI-00108: Open expect the file [string][string] to exist.
Oracle Errors 
