aiaiDBA

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

13718043309

010-86462881

ORA-12032: cannot use rowid column from materialized view log on "string"."string"

ORA-12032: cannot use rowid column from materialized view log on "string"."string"
Cause: The materialized view log either does not have ROWID columns logged, or the timestamp associated with the ROWID columns is more recent than the last refresh time.
Action: A complete refresh is required before the next fast refresh. Add ROWID columns to the materialized view log, if required.

请先 登录 后评论

1 个回答

小智
ORA-12032:不能使用rowid列从物化视图登录“ string ”。“ string ”,
.原因:实例化视图日志没有记录ROWID列,或者与ROWID列相关联的时间戳比上次刷新时间更新。,
.操作:在下一次快速刷新之前需要完全刷新。如果需要,将ROWID列添加到实例化视图日志中。,
.
请先 登录 后评论