This discussion is archived
3 Replies Latest reply: Feb 16, 2012 2:56 AM by spajdy RSS

Materialized View is not refreshing data - Oracle DB 10gR2

872653 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points