Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> replication under the microscope : [Q]
------------698C3D624B890 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii
all the changes in updatable snapshot are writen to a log in def$_calls.
so ... when you make a call to dbms_snapshot.refresh('table name')
ALL the changes from ALL the tables are passed to the master regradless of the table name.
who are oracle kidding ?
------------698C3D624B890 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii
<HTML><BODY>
<DT> all the changes in updatable snapshot are writen to a log</DT>
<DT> in def$_calls.</DT>
<DT> </DT>
<DT> so ... when you make a call to dbms_snapshot.refresh('table name')</DT>
<DT> </DT>
<DT> ALL the changes from ALL the tables are passed to the master </DT>
<DT> regradless of the table name. </DT>
<DT> </DT>
<DT> who are oracle kidding ?</DT>
<DT> </DT>
</BODY>
</HTML>
------------698C3D624B890--
Received on Thu Mar 06 1997 - 00:00:00 CST