Oracle：提交后物化视图日志未清除
我有许多物化视图日志，这些日志在提交后不会自行清除。我如何找出这些日志在提交时未自行清除的原因？
I have a number materialized view logs which are not clearing themselves after commit. How do I find out why these logs are not clearing themselves on commit?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您暗示您的 MV 是为了刷新 ON COMMIT 而创建的，但事实真的是这样吗？ MV什么时候更新？ ON COMMIT、ON DEMAND 或某种刷新计划？快速刷新并不是 ON COMMIT 的同义词，它只是意味着增量刷新而不是完全刷新。
You imply that your MV's were created to refresh ON COMMIT, but is that really the case? When are the MV's refreshed? ON COMMIT, ON DEMAND, or on some sort of refresh schedule? Fast refresh is not synonymous with ON COMMIT, it just means an incremental refresh as opposed to a full refresh.
我知道这不是你的情况，但如果按需刷新后 MVlog 未清除：
如果基表和 MV 处于不同版本的 ORACLE（即源是 11g，目标是 10g），则它们注册时会出现问题（如果我没记错的话）并且有些情况刷新后不会删除de MV（这发生在我身上，我截断了MVlogs直到源数据库升级）。
I understand it is not your case, but in case the MVlog is not cleared after refresh on demand:
If the base table and MV are in different version of ORACLE(ie source is 11g and dest is 10g), they would have problem to register(if I exactly recall) and there are situations when it does not delete de MV after refresh(It happened to me, I truncated the MVlogs until the upgrade of source database).