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

Gillian,

  use the TRUNC function on sysdate:

create (or alter) snapshot ..
refresh next trunc(sysdate) + 8

Hope this helps !
Rob van den Berg
Geodesie & Infradata
Dutch Railways

Gillian wrote in message <351157CD.4386A065_at_entergy.com>...
>I want to set my FAST snapshot to refresh once per day at 8pm.
>
>What do I say for START WITH and NEXT?
>
>Much appreciated.
>Gillian
>zmkj04_at_hotmail.com
>
Received on Fri Mar 20 1998 - 00:00:00 CST