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_C D, 1)
|| RPAD(BTN_SFX, 4) || RPAD(BTN_ST_CD, 1)BLG_ACCT_TLPH N_NO
from CSBAN10V@UCDWP0 01
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
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_C D, 1)
|| RPAD(BTN_SFX, 4) || RPAD(BTN_ST_CD, 1)BLG_ACCT_TLPH N_NO
from CSBAN10V@UCDWP0 01
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