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: Repication through Trigger
Next Topic: ORA-26563: renaming this table is not allowed
Goto Forum:

Current Time: Mon Oct 24 15:46:59 CDT 2016

Total time taken to generate the page: 0.10016 seconds