Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Materialized view replication problem
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