|
-
I set up a master and snapshot site on 2 different machines.
snapshot site contains one refresh group with few simple snapshot tables.
so far, I only can manually "force" refresh the snapshot site.
using dbms_refresh.refresh('groupname');
could anyone tell me how to make the refresh automatically?
on master site:
repadmin (interval 6 sec)
dbms_defer_sys.schedule_purge (interval=>/*6:Secs*/ sysdate + 6/(24*60*60)
on snap**** site:
snapadmin (all 3 interval are 6 sec)
dbms_defer_sys.schedule_push(interval=>/*6:Secs*/ sysdate + 6/(24*60*60);
dbms_defer_sys.schedule_purge(inerval=>/*6:Secs*/ sysdate + 6/(24*60*60);
dbms_refresh.make(/*6:Secs*/ sysdate + 6/(24*60*60);
init.ora
job_queue_interval=10
job_queue_processes=2
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|