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

PLS-00562: a function must return a type.

1 Answers  


ORA-13450: GeoRaster metadata layerInfo error

1 Answers  


ORA-13436: GeoRaster metadata dimensionSize error

1 Answers  


ORA-13851: Tracing for client identifier string is already enabled

1 Answers  


ORA-26717: SCN limit reached

1 Answers  


ORA-22064: invalid NLS parameter string [string]

1 Answers  


ORA-23408: this replication operation is not supported in a mixed configuration

1 Answers  


ORA-28261: CURRENT_USER can not be used in PLSQL Definer's Right procedure.

1 Answers  


ORA-06519: active autonomous transaction detected and rolled back

1 Answers  


RMAN-08515: archive log filename=string thread=string sequence=string

1 Answers  


ORA-21560: argument string is null, invalid, or out of range

1 Answers  


ORA-01577: cannot add log file 'string' - file already part of database

1 Answers  


Categories