refresh snapshot on ORACLE 8.1.X

From: olivier <odi_at_microresearch.be>
Date: 13 May 2003 06:24:25 -0700
Message-ID: <7413cdbe.0305130524.177ca736@posting.google.com>

Hello

We have here a problem with our snapshot on a Oracle8.1.7 database.

So, i have a snapshot A on host H1 declared on a table T on host H2 with a dblink.

Here's the sequence of events (on H1)

select * from A
-- 1000 records

drop dblink......

refresh snapshot A (fast or force)
--> error because there's no dblink (quite normal)

select * from A;
-- no rows.
Why no rows ? It seems that in Oracle7.3.4 (our previous database), the latest select still gave 1000 records. Received on Tue May 13 2003 - 08:24:25 CDT