Re: Snapshot fast: what a problem!

From: Kai Regi <kai_at_rs.ee>
Date: Tue, 07 Nov 2000 11:36:34 +0200
Message-ID: <3A07CD22.AEB444EA@rs.ee>

Dave A wrote:

> In the
> meantime, you might want to change the snapshot from a fast refresh to a
> FORCE refresh. FORCE performs a FAST refresh if possible and a COMPLETE if
> not. That way at least the snapshot gets done while you are working on a
> solution.
>

Do not use FORCE refresh. Force refresh first truncates the snapshot table (named SNAP$_...), commits the transaction and then tries to get all rows from master table. It means that for a while your snapshot is empty, all users see it empty too. And if refresh is unsuccessful, your snapshot remains empty.

Kai Received on Tue Nov 07 2000 - 03:36:34 CST