创建物化视图test_view,并每隔一小时刷新一次数据
create materialized view test_view refresh force on demand
start with sysdate next trunc(sysdate,'mi')+1/24 --每隔一小时刷新一次
as select polno from pol_main
创建物化视图test_view,并每隔一小时刷新一次数据
create materialized view test_view refresh force on demand
start with sysdate next trunc(sysdate,'mi')+1/24 --每隔一小时刷新一次
as select polno from pol_main