i created materialized view log on my master server as following...
create materialized view log on usermaster;
..... now on the replication server(the server where i wish to replicate my data) i created a materialized view as....
create materialized view usermaster refresh force start with sysdate next sysdate+1/(24*60) as (select * from usermaster@srv)
where srv is the name of the database link.....
the problem: is that the replication does not happen automatically.. i hav to refresh it myself.. i have waited for about two days now.... i am working on oracle 10g on redhat 4.
create materialized view log on usermaster;
..... now on the replication server(the server where i wish to replicate my data) i created a materialized view as....
create materialized view usermaster refresh force start with sysdate next sysdate+1/(24*60) as (select * from usermaster@srv)
where srv is the name of the database link.....
the problem: is that the replication does not happen automatically.. i hav to refresh it myself.. i have waited for about two days now.... i am working on oracle 10g on redhat 4.