Creating snapshot to refresh everyday at 9:00 pm.

Hi,
I am trying to create a snapshot that will automatically refresh daily at 9:00 pm. Will the following statement do it? create snapshot snapshot_name
pctfree 5 pctused 40
tablespace xxx
storage (initial 10M next 1M pctincrease 0) refresh complete
start with sysdate
next (sysdate+1)+21/24
as select * from emp_at_dblink;

Please let me know..
Thanks,

--

• Ben Kim National Futures Asso. *
• (847) 699-5000 Ext) 2984 Database Analysis *
• E-mail dosa_at_tezcat.com *
• bkim_at_nfa.futures.org *
• http://www.tezcat.com/~dosa *

  ---