Oracle-L: RE: Snapshots

From: Santosh Varma <vsantosh_at_psi.soft.net>
Date: Tue, 11 Mar 2003 19:43:41 -0800
Message-ID: <F001.0056719B.20030311194341@fatcity.com>

Thanks to all who replied...
santosh

-----Original Message-----
Sent: Tuesday, March 11, 2003 8:13 PM
To: Santosh Varma; Multiple recipients of list ORACLE-L

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: Santosh Varma
  INET: vsantosh_at_psi.soft.net

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 - 21:43:41 CST