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

Oracle Error Message

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

Reason for the Error

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.

Solution

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