I created a materialized view log on table DUMMY_TAB as shown below:

create materialized view log on DUMMY_TAB with primary key including new values;

Primary key for the table DUMMY_TAB is trans_id.In this table if any date is added i want to refresh the materialized view.

Then i created materialized view on table DUMMY_TAB as follows:

create materialized view temp_view
build...