Bing Wu wrote:
> 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
And *how* did you come to the conclusion it doesn't
work? Refreshes every minute may not happen as your
standard mask rounds to the day (that is, 12 o'clock
noon).
Did you check when the next job was scheduled?
--
Regards,
Frank van Bortel
Received on Thu Apr 14 2005 - 07:19:32 CDT
