-
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
-
have you tried to use
dbms_snapshot.refresh('SNAP');?????????
-
what is 'SNAP'? suppose put in group name, snapshot name/w method,..
Here is the result:
execute dbms_snapshot.refresh('SNAP');
ERROR at line 1:
ORA-23401: snapshot "SNAPADMIN"."SNAP" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 140
ORA-06512: at line 1
-
After you make snapshot you should adjust how often you want the snapshot will be executing.
Example:
alter snapshot [snapshot] refresh next [time period];
Time period is in days, so if you need minutes (sysdate+5/1440) = 5 min.
After this snapshot will be execute every 5 minutes.
Nothing more you should set.
-
make job_queue_processes=5..8
-
See the following syntax for refreshing snapshots having a list of snapshots to refresh everyday at 4 am.
/* contains all the snapshots for refresh */
begin
dbms_refresh.make('xyzrod.xyzrod_ref',
'xyzrod.usps_suffix,
xyzrod.usps_abrev,
xyzrod.fips_country_code,
xyzrod.usps_state,
xyzrod.ems_msag_community,
xyzrod.pbc_saf',
trunc(sysdate) + 19/24, 'trunc(sysdate + 1) + 4/24');
end;
/
execute dbms_refresh.refresh('xyzrod.xyzrod_ref')
[Edited by sreddy on 02-08-2001 at 08:47 AM]
-
catrep
Are you sure Did you run catrep.sql? it is necessary.
