Originally posted by vld
Hi guys, had a question on materialized views.
I have trouble automatically replicating a materialized view.
here is what I did
First I created a materialized view log for the table in the master site. Then I created a data base link between the two databases.
Then at the remote site I try to create the materialized view as follows
create materialized view mv_students
start with sysdate
next sysdate + 10 /86400
select * from students@orcl;
The matirialized view was created successfully but didn't replicate the changes to the materialized view.
however when I issued the refresh command manually all the changes were upgraded
Look at dba_jobs and see if a refresh job was created. IF not, then create the job. If there is a job, then is JOB_QUEUE_PROCESSES set? This is needed to start the background process that runs the jobs in dba_jobs.
Thanks for the reply patric, I checked the DBA_Jobs view, and the
Next_day value was set to 01-Jan-00 but the last day value was set to
29-Aug-03. I am not sure how that happened I am pretty sure I set the value of Next Day value to sysdate during materialized view creation.
I am using Oracle 9i , and the job_queue_processes was set to a default value of 10. but when I issued following command
ps -ef | grep snp
I couldn't see any background processes, so I am not really sure , I am a bit confused about that as well. Any suggestions?