Home » Server Options » Replication » Refresh Materialized Views which are dependent on others MV (Oracle 11g R2, Windows 7)
Refresh Materialized Views which are dependent on others MV [message #606561] Sun, 26 January 2014 23:58 Go to next message
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

Re: Refresh Materialized Views which are dependent on others MV [message #606563 is a reply to message #606561] Mon, 27 January 2014 00:33 Go to previous message
Michel Cadot
Messages: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Use DBMS_REFRESH to create a mview group and refresh.

Report message to a moderator

Previous Topic: Golden gate monitoring script for struck processess
Next Topic: MV fast refresh fails with 01031: insufficient privileges
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 19 23:38:03 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.