OraFAQ Forum: Replication » Materialized View is not refreshing data Automatically

Home » Server Options » Replication » Materialized View is not refreshing data Automatically (Oracle DB 10gR2 (10.2.0.4), Windows 2003 Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Materialized View is not refreshing data Automatically [message #543385]

Tue, 14 February 2012 09:02

gynanda
Messages: 33
Registered: November 2007

Member

Hi,

I have created a MV on Oracle 10gR2 using dblink. Source database is AS400 DB2.

MV script:

 

CREATE MATERIALIZED VIEW MV_BU 
TABLESPACE TB_XXX
PCTUSED    0
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            FREELISTS        1
            FREELIST GROUPS  1
            BUFFER_POOL      DEFAULT
           )
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
BUILD IMMEDIATE
REFRESH FORCE
START WITH TO_DATE('13-feb-2012 17:49:27','dd-mon-yyyy hh24:mi:ss')
NEXT SYSDATE +1/(60*24)      
WITH PRIMARY KEY
AS 
SELECT *
  FROM TAB_BU@xxx_dta;

Above query should be refreshing the data every minute but I realized that its not doing it.

Can someone explain me if I am missing something or doing something wrong?

Thanks in advance.

Report message to a moderator