Re: Snapshot Refresh two times a day

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Mon, 25 Nov 2002 05:45:24 -0600
Message-ID: <uu43alcdm7qk2d@corp.supernews.com>

You can use DBMS_JOB to schedule it to run a second time.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Marco Handels" <Marco.Handels_at_web.de> wrote in message news:arqa01$2vj$1_at_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 Mon Nov 25 2002 - 05:45:24 CST