Re: Oracle Refresh from avnish

From: Avnish Rastogi DTA <avnish_at_TULNEPZ.UNISYS.COM>
Date: Tue, 20 Feb 1996 12:50:45 +0530
Message-Id: <9602200655.AA31113@alice.jcc.com>

Hi
Oracle Snapshots are not refreshing automatically. Once a snapshot is refreshed manually, after that it refreshed automaticall. anybody can tell, why it is happening
create statement is
create snapshot ..
refresh fast
start with sysdate
next sysdate+1
as
select * from ..

SNAPSHOT_REFRESH_PROCESSES=1
snapshot_refresh_interval=60
snapshot_refresh_keep_connections=FALSE
job_queue_interval=60

job_queue_keep_connections=FALSE
job_queue_processes=1 Received on Tue Feb 20 1996 - 01:55:07 CST