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.

 

 

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


Current Time: Fri Mar 29 06:55:21 CDT 2024