Oracle物化视图错误
我已经在生产中运行了具体化的视图，但兔子在刷新方面遇到了问题。错误信息是
ORA-32411: 物化视图定义查询超出最大长度
出现问题的为 76kb、70kb、75kb 和 67kb。除了拆分查询之外，还有什么可以做的吗？每个脚本都是一个很长的查询，因此很难拆分。
I have materialized views that ran in production but hare having problems refreshing. The error message is
ORA-32411: materialized view definition query exceeds the maximum length
The ones that are having the problems are 76kb,70kb,75kb, and 67kb. Is there anything that can be done, besides splitting up the query? The scripts are one long query each so it will be hard to split up.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
将物化视图重新创建为视图，然后重新编译物化视图选择语句，因为
我不认为视图的长度存在限制。我还发现这使得更新 MV 查询变得非常简单，因为您只需重新编译视图，而不是删除并重新创建 MV。
Recreate your materialized views as just views, and then recompile your materialized view select statement as
I don't believe there is a limit to how long a view can be. I've also found this makes updating the MV query quite simple as you only have to recompile the view instead of dropping and recreating the MV.