Snapshot not refresh

From: Simone Celli_Marchi <celli_at_cantina.students.cs.unibo.it>
Date: 2000/07/24
Message-ID: <8lhs03$hcc$1@le.cs.unibo.it>#1/1

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 Mon Jul 24 2000 - 00:00:00 CDT