ORACLE物化视图

来源：互联网发布：淘宝的读书软件编辑：程序博客网时间：2024/06/06 03:54

物化视图详细解释：

http://blog.csdn.net/tianlesoftware/article/details/4713553

老杨的:

http://blog.itpub.net/4227/viewspace-68579

最近做了一个关于物化视图快速刷新的改造，需要做嵌套物化视图，对于单表可以min,max聚集函数可以快速刷新的，需要加count(columns)之外还要加count(*)具体还需要才可以不然会报错：

ORA-32314: REFRESH FAST of "string"."string" unsupported after deletes/updates

Cause: One or more deletes or updates has been performed on one or more of the detail tables referenced by the specified materialized view. This materialized view does not support fast refresh after deletes or updates.

Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after deletes or updates using the DBMS_MVIEW.EXPLAIN_MVIEW() API.

后续需要实验补上……

阅读全文

0 0