Refresh Materialized views

[st2000]

create materialized view <mv>
refresh complete on commit
enable query rewrite as
select acctnum, sum(bytes) bytes, count(bytes) c_bytes, count(*) from table1 group by acctnum;