Re: Snapshot not refresh

Hi,

The problem is in the math. 5/60 * 24 equals 2. So the snapshot refreshes every 2 days. Try 5/(60*24).

regards,

Patrick Diks

Simone Celli_Marchi wrote:

> Hi,
>
> I have a database orc4 with this snapshot:
>
> create snapshot person
> refresh fast
> start with sysdate
> next sysdate + 5/60 * 24
> with primary key
> using local rollback segment rbs_estranews
> as
> select * from person_at_orc3;
>
> On orc3 I have this snapshot log:
>
> create snapshot log on person
> with primary key;
>
> When I create the snapshot the table is populated, but if I made a change on
> person_at_orc3, this change is not propagated in 5 minutes. If I force the
> refresh with dbms_snapshot.refresh() it work.
>
> Any idea?
> Thank you.
>
> --
> SysAdm on cantina.students.cs.unibo.it
> Undergraduate student of Computer Science
> http://caristudenti.cs.unibo.it/~celli
> Key fingerprint = D8BD F3D0 00A5 9C96 4A07 DE62 2A4C EDE1 06AA E5BC
Received on Tue Jul 25 2000 - 00:00:00 CDT