Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER SNAPSHOT START WITH sysdate
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