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

Thread: MV Refreshing Problem

Hybrid View

  1. 06-11-2003, 02:55 AM #1
    RAFF
    RAFF is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 06-11-2003, 04:31 AM #2
    TomazZ
    TomazZ is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width