ORA-26805: Queue “string”.”string” has rule based subscribers.

文档解释

ORA-26805: Queue “string”.”string” has rule based subscribers.

Cause: The combined capture and apply optimization could not be used since the queue had rule based subscribers.

Action: Make sure queue has no rule based subscribers before starting apply and capture.

ORA-26805:表示队列string.string中有基于规则的订阅者。

官方解释

当用户尝试添加一个订阅者到队列string.string时,如果此队列具有基于规则的订阅者,则ORA-26805将被返回。

常见案例

用户将尝试向队列中添加订阅者时,可能会遇到ORA-26805错误,因为此队列具有基于规则的订阅者。

一般处理方法及步骤

1.将现有的订阅者更改为基于规则的订阅者

2.禁用现有的基于规则的订阅者

3.将其移到另一个队列

4.重新启用基于规则的订阅者

5.添加新的订阅者

你可能感兴趣的