GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Insufficient priviege issues while creation of refresh FAST on commit MV alone.

edited Feb 1, 2021 1:55PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center