From: fvanbortel@netscape.net   
      
   Pink Panther wrote:   
      
   > Hi All,   
   >   
   > Sorry this may be a repost as first attempt died on me...   
   >   
   > I have a set of 50 materialized views that are populated every morning.   
   >   
   > However 2 of the materialized views contain no records (I know the master   
   > does contain records).   
   >   
   > None of the jobs are broken and all run as scheduled.   
   >   
   > When I use DBA Studio and goto the refresh groups and manually run the job   
   > (clicking the button 'manual refresh' or somesuch) hey presto the   
   > snapshot's populated. It 'disappears' the next morning.   
   >   
   > The other oddity is that when I run the SQL to generate the materialized   
   > view in Free Toad no records are returned. However using SQL Plus the   
   > correct results set is returned (same user in both sessions). So I assume   
   > I've go the relevant permissions on the master tables.   
   >   
   > Anyone got any pointers?   
   >   
   > Regards,   
   >   
   > Peter   
   Try running the jobs manually, and see what happens then   
      
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)