ORACLE物化视图语法Oracle认证考试

文章作者 100test 发表时间 2010:02:10 19:58:34
来源 100Test.Com百考试题网

　　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.

　　0drop materialized view log on TableName.

　　0drop materialized view ViewName.

　　exec DBMS_MVIEW.REFRESH (CYTS.VM_ACCBILL_JOB_FEE).