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

Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER SNAPSHOT START WITH sysdate

Re: ALTER SNAPSHOT START WITH sysdate

From: Iurie Jigalov <IJigalov_at_tvguide.ca>
Date: Mon, 29 Nov 1999 18:30:24 GMT
Message-ID: <4Dz04.71981$up3.110242@news21.bellglobal.com> 





Yes, refresh will be at 07:00 AM next day, but time of creation is SYSDATE.




>When I issue that command, or


>ALTER SNAPSHOT PLAYER REFRESH COMPLETE START WITH SYSDATE NEXT



>trunc(sysdate)  + 31/24;


>Andrey Dmitriev eFax: (978) 383-5892  Daytime: (917) 373-5417


>AOL: NetComrade ICQ: 11340726 remove NSPAM to email




Received on Mon Nov 29 1999 - 12:30:24 CST












Original text of this message













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