469,081 Members | 1,834 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

Scheduling Snapshot Refreshes

Hi
Need help here. The following is the script to create one of our
snapshots.

CREATE SNAPSHOT PREEM_VIEW_SNP
PCTFREE 0
PCTUSED 99
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 25600 K
NEXT 5120 K
MINEXTENTS 1
MAXEXTENTS 505
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT)
TABLESPACE BP_DATA
LOGGING
NOCACHE
NOPARALLEL
USING INDEX PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT)
REFRESH COMPLETE
NEXT TRUNC(SYSDATE+1) + 6.5/24
WITH ROWID
USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS
select cust_id customer_id,BTN || BTN_CUST_CD || RPAD(BTN_SORT_CD, 1)
|| RPAD(BTN_SFX, 4) || RPAD(BTN_ST_CD, 1)BLG_ACCT_TLPHN_NO
from CSBAN10V@UCDWP001
where ACCT_MKT_UN_ID in ('C', 'D', 'F', 'G', 'I',
'L', 'O', 'P', 'R', 'S', 'V', 'W')
Im concerned about the NEXT TRUNC(SYSDATE+1) + 6.5/24 part. It says
the snapshot refreshes every day at 6:30 am.
I need to schedule the refreshes every day except Saturday and Sunday.
Got any idea how can I do that?

Prash
Jul 19 '05 #1
0 1224

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ozy | last post: by
6 posts views Thread by Tony Proctor | last post: by
8 posts views Thread by Jean-Marc Blaise | last post: by
3 posts views Thread by Alphonse Giambrone | last post: by
reply views Thread by perhiyar | last post: by
4 posts views Thread by Dinsdale | last post: by
Ritchie
2 posts views Thread by Ritchie | last post: by
reply views Thread by Prash | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.