From: PinkPanther2003@mail.com   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)