From: fbortel@home.nl   
      
   Prashant wrote:   
   > Hi I have a problem with refreshing of Mviews , I will narrate every   
   > thing step by step:   
   >   
   > 1.create table a (a number);   
   >   
   > 2.insert into table a values(&a); (after inserting 2 rows and   
   > commiting)   
   >   
   > 3. create MATERIALIZED view b REFRESH WITH ROWID START WITH SYSDATE   
   > NEXT sysdate + 2/1440 as select * from a;   
   >   
   > Mview created   
   >   
   > 4. insert into a values(&a); 9after inserting 2 more rows and   
   > commiting)   
   >   
   > 5.select * from a;   
   >   
   >      4 rows selected   
   >   
   > 6. select * from b;   
   >   
   >      2 rows selected (BUT HERE IT SHOULD BE 4 ROWS)( EVEN WAITING FOR   
   > 10   MIN ,     NOTHING IS COMING)   
   >   
   >   
   > WHATS GOING ON..   
   >   
   > if i do the same on diffrent server it works, but not here..   
   >   
   > then i thought checking some parameters   
   >   
   > the parameters i checked with values are :   
   >   
   > query_rewrite_enabled                boolean TRUE   
   > query_rewrite_integrity              string  ENFORCED   
   >   
   >   
   > i guess both are fine,   
   >   
   > now iam not looking to go for fast refreshes and rightnow iam using   
   >       " EXEC DBMS_MVIEWS.REFRESH('B')" to refresh it..   
   >   
   > Can u please help me out, what Iam doing wrong..   
   >   
   > It would be great if u mail me also on my personal mail id   
   >   
   >        khanna_prashant@rediffmail.com   too , Thanks alot in advance,   
   > Prashant Khanna   
      
   I miss the Generate MV support part....   
      
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)