Home » Server Options » Replication » Materialized View is not refreshing data Automatically (Oracle DB 10gR2 (10.2.0.4), Windows 2003 Server)
Materialized View is not refreshing data Automatically [message #543385] Tue, 14 February 2012 09:02 Go to next message
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.
Re: Materialized View is not refreshing data Automatically [message #543397 is a reply to message #543385] Tue, 14 February 2012 10:21 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter job_queue

Regards
Michel
Previous Topic: streams and required_checkpoint_scn
Next Topic: how to replicate
Goto Forum:
  


Current Time: Sun Apr 20 09:48:41 CDT 2014

Total time taken to generate the page: 0.05601 seconds