How to fix the Oracle error ORA-26845: Found “string” active split rows with the same cloned string Capture “string” in DBA_STREAMS_SPLIT_MERGE?

In this post, you’ll learn more about the Oracle ErrorORA-26845: Found “string” active split rows with the same 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-26845: Found “string” active split rows with the same cloned string Capture “string” in DBA_STREAMS_SPLIT_MERGE

Reason for the Error ORA-26845: Found “string” active split rows with the same cloned string Capture “string” in DBA_STREAMS_SPLIT_MERGE

In DBA_STREAMS_SPLIT_MERGE, for active split rows, the column CLONED_CAPTURE_NAME should be unique. However, multiple rows were found whose ACTION_TYPE column is ‘SPLIT’, ACTIVE column is ‘ACTIVE’ and have the same CLONED_CAPTURE_NAME.

How to fix the Error ORA-26845: Found “string” active split rows with the same 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 rows were inserted and call DBMS_STREAMS_ADM.RECOVER_OPERATION() for error recovery.