create table dropme_small (id primary key, val)
as select rownum, 'value #'||rownum from dual connect by level < 1000;
Table created

-- раскомментируйте для fast refresh
--create materialized view log on dropme_small;

create materialized view dropme_smallcopy
refresh on commit complete --fast
as select * from dropme_small
;
Materialized view created

select * from dropme_small where id = 183;
        ID VAL
---------- -----------------------------------------------
       183 value #183

update dropme_small set val = 'Changed at '||to_char(sysdate,'yyyy-mm-dd"T"hh24:mi:ss') where id = 183;
1 row updated

select * from dropme_smallcopy where id = 183;
        ID VAL
---------- -----------------------------------------------
       183 value #183

commit;
Commit complete

select * from dropme_smallcopy where id = 183;
        ID VAL
---------- -----------------------------------------------
       183 Changed at 2019-10-17T16:04:53

SQL>