ORACLE 物化视图语法

create materialized view [view_name]

　　refresh [fast|complete|force]

　　[

　　on [commit|demand] |

　　start with (start_time) next (next_time)

　　]

　　as

　　{创建物化视图用的查询语句}

　　create materialized view log on TableName;

　　drop materialized view log on TableName;

　　drop materialized view ViewName;

　　exec DBMS_MVIEW.REFRESH ('CYTS.VM_ACCBILL_JOB_FEE');