3 Replies Latest reply: Feb 16, 2012 4:56 AM by spajdy RSS

    Materialized View is not refreshing data - Oracle DB 10gR2

    872653
      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.