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

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

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: Sat May 25 15:07:52 CDT 2024