Re: FAST snapshot to refresh once per day at 8pm.

From: Brett Neumeier <random_at_nospam.com>
Date: 1998/03/24
Message-ID: <6f9frr$osa@eve.enteract.com>#1/1

Rob van den Berg <rvdbNoSpam_at_gni.ns.nl> wrote:
> create (or alter) snapshot ..
> refresh next trunc(sysdate) + 8

As written, this will actually set the refresh to happen every eight days, at midnight.

What is actually desired is:

	refresh fast start with sysdate 
		next trunc(sysdate + 1) + 8/24;

(for 8 am the next day)

Or: next trunc(sysdate + 1) + 20/24;

(for 8 pm the next day)

The trunc(sysdate + 1) evaluates to midnight of the next day; the fractional date added to it is the number of hours to be used as an offset to that date.

-bn Received on Tue Mar 24 1998 - 00:00:00 CST