In this post, you’ll learn more about the Oracle ErrorORA-26805: Queue “string”.”string” has rule based subscribers. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-26805: Queue “string”.”string” has rule based subscribers.
Reason for the Error ORA-26805: Queue “string”.”string” has rule based subscribers.
The combined capture and apply optimization could not be used since the queue had rule based subscribers.
How to fix the Error ORA-26805: Queue “string”.”string” has rule based subscribers. ?
You can fix this error in Oracle by following the below steps
Make sure queue has no rule based subscribers before starting apply and capture.