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

Oracle Error Message

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

Reason for the Error

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.

Solution

Check trace to see how the rows were inserted and call DBMS_STREAMS_ADM.RECOVER_OPERATION() for error recovery.