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.