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');