Database Software

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.