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: 54
Registered: November 2013
Location: Dhaka
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?

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: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Use DBMS_REFRESH to create a mview group and refresh.

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


Current Time: Sun Dec 21 00:18:08 CST 2014

Total time taken to generate the page: 0.08081 seconds