How to fix the Oracle error ORA-26844: Found “string” active automatic split jobs for string Capture “string” in DBA_STREAMS_SPLIT_MERGE?

In this post, you’ll learn more about the Oracle ErrorORA-26844: Found “string” active automatic split jobs for string Capture “string” in DBA_STREAMS_SPLIT_MERGE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26844: Found “string” active automatic split jobs for string Capture “string” in DBA_STREAMS_SPLIT_MERGE

Reason for the Error ORA-26844: Found “string” active automatic split jobs for string Capture “string” in DBA_STREAMS_SPLIT_MERGE

Only one active split job is allowed for each GoldenGate, XStream or Streams Capture, but multiple active automatic split jobs were found in DBA_STREAMS_SPLIT_MERGE.

How to fix the Error ORA-26844: Found “string” active automatic split jobs for string Capture “string” in DBA_STREAMS_SPLIT_MERGE ?

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

Check trace to see how the jobs were submitted and drop them.