You are here: Home // Oracle 11g // 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

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'. See the solution below.

Error solution: Either set the RETRY_DELAY to zero or upgrade the queue table to 8.1 compatible using the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: Dieta plaż południowych randki wczasy odchudzajace wulkanizacja poznań Wynajem żurawi