1.建立物化视图；create materialview myview；refresh force on demand；as；select c1,c2 from table where c1>50;2.手动刷新物化视图；在pl/sql命令窗口输入如下内容，并回车；execute dbms_mview_refresh('myview','c');
