Re: Materialized views are not getting refreshed

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_at_rediffmail.com too , Thanks alot in advance,
> Prashant Khanna

I miss the Generate MV support part....

-- 
Regards, Frank van Bortel