aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

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

ORA-26845: Found "string" active split rows with the same cloned string Capture "string" in DBA_STREAMS_SPLIT_MERGE
Cause: 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.
Action: Check trace to see how the rows were inserted and call DBMS_STREAMS_ADM.RECOVER_OPERATION() for error recovery.

请先 登录 后评论

1 个回答

小智
ORA-26845:找到具有相同克隆字符串的 “ 字符串 ”活动拆分行在DBA_STREAMS_SPLIT_MERGE中捕获“ string ”,
.原因:在DBA_STREAMS_SPLIT_MERGE中,对于活动拆分行,列“CLONED_CAPTURE_NAME”应该是唯一的。但是,发现多个行的ACTION_TYPE列为“SPLIT”,“ACTIVE”列为“ACTIVE”,并且具有相同的CLONED_CAPTURE_NAME。,
.操作:检查跟踪以查看行是如何插入的,并调用DBMS_STREAMS_ADM.RECOVER_OPERATION()以进行错误恢复。,
.
请先 登录 后评论