物化视图详细解释:
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.
后续需要实验补上……