Home » Server Options » Replication » Materialized view exceptions (Oracle 10g)
Materialized view exceptions [message #281233] Fri, 16 November 2007 03:39 Go to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
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
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


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

Like DBA_REPCATLOG and DEFERROR

Babu
Previous Topic: Repication through Trigger
Next Topic: ORA-26563: renaming this table is not allowed
Goto Forum:
  


Current Time: Thu Mar 28 08:16:52 CDT 2024