OraFAQ Forum: Replication » materialized view

Home » Server Options » Replication » materialized view - invalid status

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

materialized view - invalid status [message #230355]

Wed, 11 April 2007 11:40

lotusdeva
Messages: 198
Registered: March 2005

Senior Member

Did someone had this issue? We have a materialized view that is set to refresh every 2 hours. It was refreshing fine, but for the last two days it comes out with INVALID status. I read that INVALID status does not apply to materialized views :

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1000/en/html/dbugen10/ug-workingwdb-s-5617326.html

So should we not worry? Why does the status change to INVALID? We are on Oracle 9.2. I found some bug from like 2004 on this, but it was for Oracle 8i...If anyone had this issue, many thanx!

Report message to a moderator

Re: materialized view - invalid status [message #230421 is a reply to message #230355]

Wed, 11 April 2007 22:32

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

Nope, It's also applicable to Materialized view. It may be in INVALID state, I have worked on one of the very big db (4.7 TB) Where in many activities MV is invalidated, you can manually validate by below command.

ALTER MATERIALIZED VIEW <schema.MV_NAME> COMPILE;

Regards,
Harsh

Report message to a moderator

Re: materialized view - invalid status [message #230654 is a reply to message #230421]

Thu, 12 April 2007 08:48

lotusdeva
Messages: 198
Registered: March 2005

Senior Member

right, we manually validate it. BUT, why is it happening? Every time there is a update/delete/insert view gets invalidated..

Report message to a moderator

Previous Topic:	Fast Refresh using two non-primary key tables
Next Topic:	synchronous replication applications

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 13:08:46 CDT 2013

Total time taken to generate the page: 0.07979 seconds