Oracle Error ORA-26846: Found “string” active automatic merge jobs for cloned string Capture “string” in DBA_STREAMS_SPLIT_MERGE

Oracle Error Message

ORA-26846: Found “string” active automatic merge jobs for cloned string Capture “string” in DBA_STREAMS_SPLIT_MERGE

Reason for the Error

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

Solution

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