Materialized views are not getting refreshed
Date: 7 Nov 2003 04:02:04 -0800
Message-ID: <fc4206d.0311070402.2f742810_at_posting.google.com>
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;
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 :
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
Received on Fri Nov 07 2003 - 13:02:04 CET
2 rows selected (BUT HERE IT SHOULD BE 4 ROWS)( EVEN WAITING FOR
10 MIN , NOTHING IS COMING)
query_rewrite_enabled boolean TRUE
query_rewrite_integrity string ENFORCED