FAST refresh of updatable snapshot
From: Bo Lu <bo.lu_at_hsc.utah.edu>
Date: 1996/06/01
Message-ID: <31B05FF1.58F6_at_hsc.utah.edu>#1/1
Date: 1996/06/01
Message-ID: <31B05FF1.58F6_at_hsc.utah.edu>#1/1
Hi, everyone
I just started working on Oracle's updatable snapshot.
I have one master site and one snapshot site. The thing that
confused me is that how do I tell Oracle to do FAST refresh.
I have created snapshot log on the master tables. But it seems
that the snapshot on the snapshot site still do complete refresh
even though I told it to do fast refresh in the
dbms_snapshot.refresh function. What is the trick to do fast
refresh on updatabe snapshot?
I actually got FAST refresh work once. But I could not figure
out how I did it. Any ideas?
-- Bo Lu Senior Programmer/Analyst Hospital and Clinical Informatics, U. of Utah 801-581-5964, bo.lu_at_hsc.utah.eduReceived on Sat Jun 01 1996 - 00:00:00 CEST