Home » Server Options » Replication » materialized view - invalid status
materialized view - invalid status [message #230355] Wed, 11 April 2007 11:40 Go to next message
lotusdeva
Messages: 201
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 Go to previous messageGo to next message
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 Go to previous message
lotusdeva
Messages: 201
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 14 10:42:18 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.