In this post, you’ll learn more about the Oracle ErrorORA-26846: Found “string” active automatic merge jobs for cloned 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-26846: Found “string” active automatic merge jobs for cloned string Capture “string” in DBA_STREAMS_SPLIT_MERGE
Reason for the Error ORA-26846: Found “string” active automatic merge jobs for cloned string Capture “string” in DBA_STREAMS_SPLIT_MERGE
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.
How to fix the Error ORA-26846: Found “string” active automatic merge jobs for cloned 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.