ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a
8.0 compatible multiple consumer queue
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 |
EXP-00097: Object type "string"."string" is not in a valid state, type will not be exported
NCR-04018: NCRR: Unable to create the TNS address list
PLS-00234: PARAMETER STYLE SQL may not be specified with a PARAMATERS list
ORA-39109: Unprivileged users may not operate upon other users' schemas
TNS-12638: Credential retrieval failed
ORA-29809: cannot drop an operator with dependent objects
ORA-09368: Windows 3.1 Two-Task driver unable to spawn ORACLE
ORA-06106: NETTCP: socket creation failure
ORA-24385: Application context size or index is not valid
ORA-31629: unable to allocate additional memory
EXP-00102: Resumable parameters ignored -- current session not resumable
ORA-09800: Process sensitivity label retrieval failed.