Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Snapshot Refresh two times a day

Snapshot Refresh two times a day

From: Marco Handels <Marco.Handels_at_web.de>
Date: Sun, 24 Nov 2002 11:34:40 +0100
Message-ID: <arqa01$2vj$1@nets3.rz.RWTH-Aachen.DE> 





Hi,



i would like to replicate a Oracle database. What statement must i use to
refresh the snapshots two times every day for example at 9 am and 16 pm. I
found the statement for once a day: trunc(sysdate+1)+9/24, but which
statement combined the second time ?



Thanks


Marco
Received on Sun Nov 24 2002 - 04:34:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US