Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Snapshot fast: what a problem!

Re: Snapshot fast: what a problem!

From: Kai Regi <kai_at_rs.ee>
Date: Tue, 07 Nov 2000 11:44:58 +0200
Message-ID: <3A07CF1A.36311144@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
Received on Tue Nov 07 2000 - 03:44:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US