OraFAQ Forum: Replication » Refresh Materialized Views which are dependent on others MV

Home » Server Options » Replication » Refresh Materialized Views which are dependent on others MV (Oracle 11g R2, Windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Refresh Materialized Views which are dependent on others MV [message #606561]

Sun, 26 January 2014 23:58

mokarem
Messages: 109
Registered: November 2013
Location: Dhaka

Senior Member

Hi,

The source of Materialized View 'B' is Materialized View 'A'. The base table for MV 'A' is D. Now If I UPDATE on D. MV 'A' has become stale. I need to refresh. When I refresh 'A', then only I came to know I need to refresh 'B' also.

I have around 30-35 such MV. I refresh all MV executing a user defined procedure which uses DBMS_SNAPSHOT.REFRESH.

Now how can I automate this so all MV refreshed in one go?

Report message to a moderator