Santosh,
I see that someone else has pointed you to an Oracle Tech Net document. But
the short of it is:
Snapshot or materialized view logs are placed on the source table only if
you want to do fast refreshes. Their purpose is to remember which rows in the
source table have changed.
Snapshots or materialized views are on the remote database and are copies of
the source tables.
Dick Goulet
____________________Reply Separator____________________
Author: "Santosh Varma" <[EMAIL PROTECTED]>
Date: 3/11/2003 2:59 AM
Could anybody of the list give me the correct explanation of the below ?
mechanism provided by ORACLE for table replication -> Snapshots and SNAPSHOT
LOGs
Thanks and Regards,
Santosh
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial><PRE style="TEXT-ALIGN: justify"><SPAN
style="mso-bidi-font-family: 'Courier New'"><SPAN class=102575610-11032003><FONT
size=2>Could anybody of the list give me the correct explanation of the below
?</FONT></SPAN></SPAN></PRE><PRE style="TEXT-ALIGN: justify"><FONT size=2><SPAN
style="mso-bidi-font-family: 'Courier New'">mechanism provided by ORACLE for
table replication <SPAN class=102575610-11032003>-> </SPAN></SPAN><SPAN
style="mso-bidi-font-family: 'Courier New'"><STRONG>Snapshots and SNAPSHOT
LOGs<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"
/><o:p></o:p></STRONG></SPAN></FONT></PRE><PRE style="TEXT-ALIGN: justify"><SPAN
style="mso-bidi-font-family: 'Courier New'"><FONT
size=2> <o:p></o:p></FONT></SPAN></PRE></FONT></DIV>
<DIV>
<DIV>
<DIV><FONT face=Arial><FONT size=2>Thanks and Regards,</FONT></FONT></DIV>
<DIV><SPAN class=102575610-11032003><FONT face=Arial
size=2>Santosh</FONT></SPAN></DIV></DIV></DIV></BODY></HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
