HELP! HOW TO REFRESH A SNAPSHOT?
From: Carlo Goldoni <cgoldoni_at_etnoteam.it>
Date: Wed, 3 Nov 1999 15:10:51 +0100
Message-ID: <7vpfqs$ag6$1_at_stargate1.inet.it>
[Quoted] Hi, everybody.
AS SELECT * FROM BR2.DEPT If I'm not wrong, this statement should create a snapshot and have the [Quoted] system refresh it every 5 minutes. But this does not happen! Besides, if I execute a
Date: Wed, 3 Nov 1999 15:10:51 +0100
Message-ID: <7vpfqs$ag6$1_at_stargate1.inet.it>
[Quoted] Hi, everybody.
I created a snapshot to speed up query-operations on the DB. [Quoted] The problem is that the system does not refresh it!
[Quoted] The statement I used to create the snapshot was like the following:
CREATE SNAPSHOT SNAP_BR2_DEPT
BUILD IMMEDIATE
REFRESH FORCE
[Quoted] START WITH SYSDATE + 5/1440 NEXT SYSDATE + 5/1440
AS SELECT * FROM BR2.DEPT If I'm not wrong, this statement should create a snapshot and have the [Quoted] system refresh it every 5 minutes. But this does not happen! Besides, if I execute a
[Quoted] "SELECT * FROM ALL_SNAPSHOTS", the "LAST_REFRESH" field is either NULL or [Quoted] equals to "01/01/1950 12:00:00".
Where is the mistake?
Pleas, help!
Thanks in advance, Carlo
E-mail: cgoldoni_at_etnoteam.it
Received on Wed Nov 03 1999 - 15:10:51 CET