Materialized view exceptions [message #281233] |
Fri, 16 November 2007 03:39 |
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 ?
|
|
|
|