Materialized view replication problem

From: Bing Wu <bing_at_biop.ox.ac.uk>
Date: Thu, 14 Apr 2005 12:44:11 +0100
Message-ID: <d3ll2b$2ts$1@news.ox.ac.uk>

Hi,

I have setup a materialized view replication between 2 remote 10g servers. It seems everything is working fine except scheduled refreshing is NOT working. Then I tried manual refreshing with DBMS_MVIEW.REFRESH command and it works thus eliminates firewall issues.

The command I used to create materialized is:

CREATE MATERIALIZED VIEW SCOT.EMP

        TABLESPACE USERS
        REFRESH FAST WITH PRIMARY KEY
        START WITH SYSDATE
        NEXT  SYSDATE + 1/(24*60)
        AS (SELECT * FROM SCOT.EMP_at_REMOTE_SITE);

Any thoughts?

Tia,

Bing Received on Thu Apr 14 2005 - 06:44:11 CDT