create materialized view MViewName
refresh complete on demand
start with to_date('01-01-2012 00:00:00', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE + 1/24
as
select ...
create materialized view MViewName
refresh complete on demand
start with to_date('01-01-2012 00:00:00', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE + 1/24
as
select ...