[Preeti Bajaj]

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 immediate
refresh fast
enable query rewrite as
SELECT ID, nvl2(MAX(CRE_DATE),MAX(CRE_DATE),MAX(TXN_DATE)) AS LAST_TXN_DT
from DUMMY_TAB group by ID

I got the errror:

ORA_12054:Cannot set the ON COMMIT refresh attribute for the materialized view.Can anyone help me how to resolve this error??

[amitpatel66]

Please let us know which oracle version you are using??