Scheduling Snapshot Refreshes

From: Prash <prasheen.prakash_at_qwest.com>
Date: 2 Jun 2004 10:33:15 -0700
Message-ID: <2aa93de9.0406020933.45e922b4_at_posting.google.com>

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_at_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 Received on Wed Jun 02 2004 - 19:33:15 CEST