ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a
8.0 compatible multiple consumer queue
- 1 Answers
- 2718 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 |
O2U-00205: None of the characters in a type name were legal identifier characters
ORA-12171: TNS:could not resolve connect identifier: string
TNS-12527: TNS:listener: all instances are in restricted mode or blocking new connections
ORA-22923: amount of data specified in streaming LOB write is 0
ORA-28005: invalid logon flags
ORA-13116: [string]_FACE$ table does not exist
ORA-39065: unexpected master process exception in string
RMAN-08117: channel string: the autobackup does not contain an SPFILE
NCR-01020: NCRS: Operation would block.
RMAN-06191: PL/SQL package string.string version string in string database is too new
ORA-06041: NETDNT: disconnect failed
ORA-19012: Cannot convert XML fragment to the required datatype
Oracle Errors 
