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.