Oracle-L: Re:Snapshots

From: <dgoulet_at_vicr.com>
Date: Tue, 11 Mar 2003 06:44:41 -0800
Message-ID: <F001.00565F7D.20030311064441@fatcity.com>

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" <vsantosh_at_psi.soft.net>
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: dgoulet_at_vicr.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Mar 11 2003 - 08:44:41 CST