Home » SQL & PL/SQL » SQL & PL/SQL » Materialized View corrupted (merged)
Materialized View corrupted (merged) [message #390417] Fri, 06 March 2009 04:50 Go to next message
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

Re: Materialized View corrupted [message #390422 is a reply to message #390417] Fri, 06 March 2009 05:14 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Hello,

Please read the OraFAQ Forum Guide before posting.
http://www.orafaq.com/forum/t/88153/0/


Quote:
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

. How can we conform whether or not Materialized Views corrupted.
3. How can we resolve the corrupted Materialized View.

.


Materialized View Corrupted?? NO; I hope may be the refresh not happen? You need to confirm using DBA_MVIEWS (last_refreshed_date)

Suppose; Your development team done any changes in source table?? (Mean DDL Changes); If yes; you need to re-create your materialized view
Re: Materialized View corrupted (merged) [message #390426 is a reply to message #390417] Fri, 06 March 2009 05:25 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
I am sure, DDL has not changed.......
Re: Materialized View corrupted (merged) [message #390428 is a reply to message #390417] Fri, 06 March 2009 05:28 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Thanks for your help gentlebabu.....

Is there any data dictionary where we can find the history of the MVs i.e tracking history of it.

Re: Materialized View corrupted (merged) [message #390429 is a reply to message #390428] Fri, 06 March 2009 05:31 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
This history is kept in your Source Versioning system.
Re: Materialized View corrupted (merged) [message #390445 is a reply to message #390429] Fri, 06 March 2009 06:03 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>Is there any data dictionary where we can find the history of the MVs i.e tracking history of it.

What type refresh your following??

If FAST/FORCE then check you materialized view log from source database..

Re: Materialized View corrupted [message #390448 is a reply to message #390417] Fri, 06 March 2009 06:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Do you have any actual information for us?

Oracle error messages, Alert log details, trace files - anything like that?

Re: Materialized View corrupted (merged) [message #390490 is a reply to message #390417] Fri, 06 March 2009 10:19 Go to previous messageGo to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
I am sorry..I dont have...DBA team has just told MV corrupted.

Application was not showing any error except showing old timestamp.

we are following complete refresh.

Regards,
Pointers.
Re: Materialized View corrupted (merged) [message #390501 is a reply to message #390490] Fri, 06 March 2009 12:03 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>> has just told MV corrupted.

How your saying Materialized View corrupted ??
Previous Topic: Adding Time Value having varchar2 datatype (merged)
Next Topic: TIME COLUMN
Goto Forum:
  


Current Time: Sun Feb 16 19:54:14 CST 2025