aiaiDBA

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

13718043309

010-86462881

QSM-02192: commit SCN based MV log is not in consistent state

QSM-02192: commit SCN based MV log is not in consistent state
Cause: The capability in question is not supported when the relevant materialized view log is not in consistent state due to the failure when populating the mapping table of SYS.SNAP_XCMT$.
Action: Perform a complete refresh of the materialized view.

请先 登录 后评论

1 个回答

小智
QSM-02192:提交基于SCN的MV日志不一致的状态,
.原因:当相关物化视图日志不一致状态时,由于在填充SYS.SNAP_XCMT $的映射表时出现故障,不支持相关功能。,
.操作:执行物化视图的完整刷新。,
.
请先 登录 后评论