By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,830 Members | 812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,830 IT Pros & Developers. It's quick & easy.

replication: fails to replicate automatically have to manually refresh

P: 1
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.
Mar 7 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.