MV Refreshing Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: MV Refreshing Problem

  1. #1
    Join Date
    May 2003
    Posts
    32

    MV Refreshing Problem

    Hi again!
    I have an Updatable Materialized view environment. Its working fine with both ways replication.
    But when i shutdown both of my Master Site and Materialized View Site PC'S and restart them again, my MV sites are not refreshing, i have to refresh them manually.
    Do i need to execute any procedures after restarting the PC's?

    Suggesstions

    RAFF

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Materialized view refreshes are done by jobs.
    After 12 failures (if master site is down) jobs get 'broken'.
    Check dba_jobs.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width