How to fix the Oracle error ORA-26793: Number of capture processes that enqueued message to queue “string”.”string” not equal to one?

In this post, you’ll learn more about the Oracle ErrorORA-26793: Number of capture processes that enqueued message to queue “string”.”string” not equal to one with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26793: Number of capture processes that enqueued message to queue “string”.”string” not equal to one

Reason for the Error ORA-26793: Number of capture processes that enqueued message to queue “string”.”string” not equal to one

Split-merge API requires only one capture process enqueued message to the queue where the propagation originated

How to fix the Error ORA-26793: Number of capture processes that enqueued message to queue “string”.”string” not equal to one ?

You can fix this error in Oracle by following the below steps

Please drop one capture, or split or merge another propagation.