Insufficient priviege issues while creation of refresh FAST on commit MV alone.
Hello Team,
I been created materialized view log on base table then when I issue on demand as follows can able to execute and create MV successfully.
create materialized view
MV_PCX_ANH
BUILD IMMEDIATE
REFRESH FAST ON DEMAND WITH PRIMARY KEY
as
select id,INSUREDGROUPOTHERDESC,OPERATIVETIMEDESCRIPTION
from pc2user.PCX_ANHINSUREDGROUP_AVI@IGW11R where INSUREDGROUPOTHERDESC is not null or OPERATIVETIMEDESCRIPTION is not null;
But we want to refresh automatically once commit issued in the base table hence if use FAST ON COMMIT as follows
create materialized view
MV_PCX_ANH
BUILD IMMEDIATE
REFRESH FAST ON COMMIT WITH PRIMARY KEY