create table mv_test_table ( columnA number, columnB number );

alter table mv_test_table add primary key ( columnA );

create materialized view log on mv_test_table with rowid (columnA, columnB) including new values;

create materialized view mv_view refresh fast on commit with rowid as select sum(columnB) from mv_test_table;