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'.
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-24038：RETRY_DELAY和MAX_RETRIES不能用于8.0兼容的多个使用者队列,
.原因：发出了CREATE_QUEUE或ALTER_QUEUE命令，其中包含为多个用户创建的非零RETRY_DELAY和QUEUE_TABLE，并且COMPATIBLE参数设置为“8.0”。,
.操作：将RETRY_DELAY设置为零或使用DBMS_AQADM.MIGRATE_QUEUE_TABLE过程将队列表升级到8.1兼容。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题