| snapshot refresh interval [message #75354] |
Thu, 10 April 2003 16:09  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
