Re: Snapshot Refreshs

From: John Blackburn <John.D.Blackburn_at_transport.qld.gov.au>
Date: 2000/06/05
Message-ID: <8hfb8m$rph1@inetbws1.citec.com.au>#1/1

L120bj <l120bj_at_aol.com> wrote in message news:20000601113132.14675.00001073_at_ng-fa1.aol.com...
> >How do I set up a snapshot to refresh every day at 5:00 AM?
> >
> >Will
> >START WITH TRUNC(SYSDATE) + 5/24
> >NEXT SYSDATE + 1
> >work?
>
> I think the start with will have to be
> TRUNC(SYSDATE + 1) + 5/24
> otherwise the initial execution time will have passed.
> HTH,
> Rob

If it is important that it always refreshes at 5:00 AM, I'd also say
NEXT trunc(sysdate+1) + 5/24

otherwise as time goes by the refresh time could creep because when NEXT is calculated may not be exactly 24 hours since the last time it was calculated.

Cheers,
John Received on Mon Jun 05 2000 - 00:00:00 CDT