aiaiDBA

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

13718043309

010-86462881

QSM-02163: cannot use object id columns from materialized view log

QSM-02163: cannot use object id columns from materialized view log
Cause: The materialized view log either does not have object id columns logged, or the timestamp associated with the object id columns is more recent than the last refresh time.
Action: A complete refresh is required before the next fast refresh. Add object id columns to the materialized view log, if required.

请先 登录 后评论

1 个回答

小智
QSM-02163:不能使用物化视图日志中的对象标识列,
.原因:物化视图日志没有记录对象ID列,或者与对象标识列相关联的时间戳记比上次刷新时间更新。,
.操作:在下次快速刷新之前需要完全刷新。如果需要,将对象标识列添加到物化视图日志。,
.
请先 登录 后评论