Materialized View corrupted (merged) [message #390417] |
Fri, 06 March 2009 04:50  |
pointers
Messages: 451 Registered: May 2008
|
Senior Member |
|
|
Hi
I got a scenario, I would request your help on the below problem statement
Problem Statement:
We use Materilized Views to get refreshed data (for every 15 mins) and show in the portal/portlet. One day the the portal was showing old timestamp. Our development team has done what ever we could, fianally contacted DBA, even they dint find any Root Cause.
But, they recreated all the Materialized Views which are invloved for that application, then we got latest timestamp. Issue resolved finally.
DBA team just told, Materilized View corrupted.
Questions:
1. Is there anything like Materialized View corrupted, if so, what does it mean and what makes a Materialized View corrupted pls expatiate the concept behind it.
2. How can we conform whether or not Materialized Views corrupted.
3. How can we resolve the corrupted Materialized View.
Regards,
Pointers.
[remove CODE tags that made this post about 3 screens wide]
[Updated on: Fri, 06 March 2009 05:00] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|