ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a
8.0 compatible multiple consumer queue



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

Post New Answer

More Oracle Errors Interview Questions

ORA-00604: error occurred at recursive SQL level string

1 Answers  


TNS-00560: extraction of name from Entrust certificate failed

1 Answers  


ORA-36704: (XSRELTBL06) workspace object should be dimensioned by workspace object.

1 Answers  


PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.

1 Answers  


ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.

1 Answers  






SQL*Loader-00952: Error calling once/data file initialization

1 Answers  


ORA-02362: error closing file: string

1 Answers  


ORA-30025: DROP segment 'string' (in undo tablespace) not allowed

1 Answers  


NNC-00400: memory exhausted

1 Answers  


TNS-01082: Running in PROXY mode

1 Answers  


DRG-11123: theme indexing is not supported

1 Answers  


ORA-14030: non-existent partitioning column in CREATE TABLE statement

1 Answers  


Categories