Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Snapshot Refreshs

Re: Snapshot Refreshs

From: L120bj <l120bj_at_aol.com>
Date: 2000/06/01
Message-ID: <20000601113132.14675.00001073@ng-fa1.aol.com>#1/1 






>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
Received on Thu Jun 01 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US