Home » Server Options » Replication » snapshot refresh interval
snapshot refresh interval [message #75354] Thu, 10 April 2003 16:09 Go to next message
Mitch
Messages: 5
Registered: April 2003
Junior Member
To refresh an Oracle8 snapshot every weekday (Monday through Friday) morning at 6:05 AM, what NEXT date expression should be used?
Re: snapshot refresh interval [message #75355 is a reply to message #75354] Fri, 11 April 2003 08:56 Go to previous message
Anand
Messages: 161
Registered: August 1999
Senior Member
SELECT TO_CHAR((ROUND(SYSDATE+1) + 6.09/24),'MM-DD-YYYY HH24:MI:SS') MY_TIME FROM dual;

MY_TIME
-------------------------
04-12-2003 06:05:24

Please try this...
----------------------------------------------
SQL> CREATE SNAPSHOT XYZ
START WITH sysdate
NEXT TO_CHAR((ROUND(SYSDATE+1) + 6.09/24),'MM-DD-YYYY HH24:MI:SS')
AS SELECT * FROM A;

Let me know how it works.
Previous Topic: Synchronous Multimaster relication
Next Topic: Application Gateway - OCN?
Goto Forum:
  


Current Time: Sun Sep 26 01:34:57 CDT 2021