ORA-26805: Queue “string”.”string” has rule based subscribers. ORACLE 报错 故障修复 远程处理
文档解释
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.添加新的订阅者
