Home » Server Options » Replication » Materialized view exceptions (Oracle 10g)
Materialized view exceptions [message #281233] Fri, 16 November 2007 03:39 Go to next message
Messages: 87
Registered: November 2007
Location: chennai
How do we tackle the exception scenarios that can occur while refreshing materliazed views.

I guess the following are the situations that could arise materialized views:

1. An intervening network or server failure
2. An intervening server shutdown
3. And also if a materialized view refresh group is experiencing problems, how do we ensure that none of the preceding situations is preventing Oracle from completing group refreshes.
4. Also when Oracle fails to refresh a group automatically, the group remains due for its refresh to complete. how to tackle this ?
Re: Materialized view exceptions [message #281557 is a reply to message #281233] Sun, 18 November 2007 04:28 Go to previous message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

If you face any error in Materialized View site you should be check in master site.


Previous Topic: Oracle Materialize View - High Redo Generation
Next Topic: Materialized view refresh
Goto Forum:

Current Time: Mon Aug 21 09:01:39 CDT 2017

Total time taken to generate the page: 0.12746 seconds