Hi,

I have a materialized view on 1 master table and a materialized view log on the table.

master table = A
MV name = A_mv
MV Log name = mlog$_A


The problem is - data inserted in A gets populated in mlog$_A, but it does not get refreshed in A_mv.snaptime column contains "1/1/4000" always.

If I use "exec dbms_mview.refresh('A_mv')"....MV gets refreshed successfully.

MV DDL -

CREATE MATERIALIZED VIEW A_MV
PCTFREE 10
PCTUSED 40
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 128 K
NEXT 128 K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT)
REFRESH COMPLETE
ON DEMAND
START WITH SYSDATE
NEXT TRUNC(SYSDATE + (1/288), 'MI')
WITH PRIMARY KEY
USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS SELECT * FROM A@FSNEW;


Please Help !