ORA-55511: Flashback Transaction experienced error in executing undo SQL

ORA-55511: Flashback Transaction experienced error in executing undo SQL
Cause: There was a constraint violation exception when executing in NOCASCADE_FORCE mode. Users could also get this error if appropriate supplemental logging is not enabled causing constraint dependencies to go unnoticed.
Action: Either use CASCADE or NONCONFLICT_ONLY options or add appropriate level for supplemental logging.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:54

ORA-55511：闪回在执行撤消SQL时遇到错误,
.原因：在NOCASCADE_FORCE模式下执行时存在约束违例异常。如果没有启用适当的补充日志记录，用户也可能会收到此错误，导致约束依赖关系不被注意。,
.操作：使用CASCADE或NONCONFLICT_ONLY选项或为补充日志添加适当的级别。,
.

aiaiDBA

13718043309

010-86462881

ORA-55511: Flashback Transaction experienced error in executing undo SQL

1 个回答

相似问题