Home » Server Options » Replication » Snaphots status='INVALID'
Snaphots status='INVALID' [message #75454] Tue, 03 February 2004 21:33
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
Hi,

We are having snapshots on our staging database. When i qry the objects which are invalid in the database I get to see 90 % of snapshot's status = INVALID. In user_mviews also their compile_status='ERROR'. How ever in other database we have same snapshots but their status in NOT INVALID.

Our snapshots are working fine and there is no errror in refreshing them also. We are using oracle 8.1.7.4.0.

Pls help.

Manish Mendiratta.

 

 

 

Report message to a moderator

Previous Topic: Updatable Snapshots on a complex view, and not on a table
Next Topic: Advanced Replication Refresh Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 11 18:45:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.