Home » Server Options » Replication » Re: Snapshot auto refresh not working, what are all the parameters to be set
Re: Snapshot auto refresh not working, what are all the parameters to be set [message #74991] Tue, 23 January 2001 07:42 Go to next message
Eddie
Messages: 23
Registered: January 2001
Junior Member
Hi,

Did you check the Advanced Replication option when install the Oracle Server?

Eddie

----------------------------------------------------------------------
Re: Snapshot auto refresh not working, what are all the parameters to be set [message #75148 is a reply to message #74991] Wed, 27 February 2002 01:37 Go to previous messageGo to next message
Vijay
Messages: 116
Registered: September 1999
Senior Member
Hi ,

check the solution given by eddie.

apart from that...
check whether
the init(sid).ora file is having the
following parameters
if u r running oracle 8 or above
1 job_queue_processess
2 job_queue_interval
is set appropriately

if u r running oracle 7.3 the
parameters are
1. snapshot_refresh_processess
2. snapshot_refresh_interval

apart from that. there is process called
SNPn which should be running at the background
for automatic replication to take place..

regards
vijay
Re: Snapshot auto refresh not working, what are all the parameters to be set [message #75187 is a reply to message #75148] Mon, 03 June 2002 09:20 Go to previous message
Terry Quataert
Messages: 1
Registered: June 2002
Junior Member
Can you tell me how to refresh materialized view hourly? I can't seem to get the right syntax. Best I can do is daily (sysdate + 1 + 12/24). Here is my create statement:

create materialized view (view_name) refresh fast start with trunc(sysdate) + 16/24 next trunc(sysdate) + 1 + 12/24 for update as select * from (remote_table_name);

Thanks Terry
Previous Topic: How can I tune my DB for using whole canal width?
Next Topic: Switch Masters with Basic (Standard) Replication?
Goto Forum:
  


Current Time: Thu Jul 16 12:04:21 CDT 2020