ORA-24057: cannot define subscriber with rule for queue string

ORA-24057: cannot define subscriber with rule for queue string
Cause: An ADD_SUBSCRIBER or ALTER_SUBSCRIBER procedure with a rule was issued on a queue for which rule based subscribers are not supported. Rule based subscribers currently are supported only for NORMAL (persistent) multi-consumer queues created using an Oracle release 8.1.0 or higher compatible queue table.
Action: Create a NORMAL multi-consumer queue in an Oracle release 8.1.0 or higher compatible queue table, and retry the call. Or, if the queue is a normal (persistent) multi-consumer queue, convert the queue table to Oracle 8.1.0 or higher compatibility and retry.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-24057：无法定义具有队列字符串规则的订户,
.原因：在不支持基于规则的订户的队列上发出了具有规则的ADD_SUBSCRIBER或ALTER_SUBSCRIBER过程。基于规则的订户当前仅支持使用Oracle版本8.1.0或更高版本兼容的队列表创建的NORMAL（持久）多消费者队列。,
.操作：在Oracle版本8.1.0或更高版本的兼容队列表中创建NORMAL多消耗程序队列，然后重试调用。或者，如果队列是正常（持久）多消费者队列，请将队列表转换为Oracle 8.1.0或更高兼容性并重试。,
.

aiaiDBA

13718043309

010-86462881

ORA-24057: cannot define subscriber with rule for queue string

1 个回答

相似问题