R: Snapshot fast: what a problem!

From: Antonio Sant <asant_at_iol.it>
Date: Tue, 07 Nov 2000 19:57:47 GMT
Message-ID: <%8ZN5.10648$BF.347477@news.infostrada.it>

"Kai Regi" <kai_at_rs.ee> ha scritto nel messaggio news:3A07CF1A.36311144_at_rs.ee...
>
> Sorry, a little mistake. I wanted to say:
>
> Do not use FORCE refresh. If fast refresh fails then 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
>

Thanks a lot to all!

You give me a lot of ideas!

But another question, such a behaviuor is normal? It's lik Oracle can invalidate the snap log by itself! Received on Tue Nov 07 2000 - 13:57:47 CST