Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_reppit012.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>About Replicating Read/Write Data Using Materialized Views</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T17:1:2Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Replicating Read/Write Data Using Materialized Views" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10703-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdpii_reppit011.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_reppit013.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdpii_reppit011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_reppit013.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BEHCEEHJ" name="BEHCEEHJ"></a><a id="TDPII057" name="TDPII057"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>About Replicating Read/Write Data Using Materialized Views<a id="sthref432" name="sthref432"></a><a id="sthref433" name="sthref433"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p><span class="bold">Updatable materialized views</span> enable users to insert, update, and delete rows in the materialized views. When an updatable materialized view is refreshed, these changes are pushed to the master site and applied to the master table.</p> <p><a href="#BEHFADHF">Figure: Updatable Materialized View</a> shows how an updatable materialized view works.</p> <div class="figure"><a id="BEHFADHF" name="BEHFADHF"></a><a id="TDPII284" name="TDPII284"></a> <p class="titleinfigure">Updatable Materialized View</p> <img src="img/tdpii083.gif" alt="Description of this figure follows" title="Description of this figure follows" longdesc="img_text/tdpii083.htm" /><br /> <a id="sthref434" name="sthref434" href="img_text/tdpii083.htm">Description of "Updatable Materialized View"</a><br /> <br /></div> <!-- class="figure" --> <p><a href="#BEHFADHF">Figure: Updatable Materialized View</a> shows that client applications can query and update an updatable materialized view at the materialized view site. These applications can also update data at the remote master site. When the materialized view initializes a refresh over the network, the refresh includes two key phases. First, transactions that have been performed on the materialized view are pushed to the master site and applied as appropriate. Next, after resolving any conflicting updates, the materialized view pulls the changed row data from the master site and applies it.</p> <p>The following topics provide more information about replicating read/write data using materialized views:</p> <ul> <li> <p><a href="tdpii_reppit013.htm#BEHIGFCF">About Replication Groups and Updatable Materialized Views</a></p> </li> <li> <p><a href="tdpii_reppit014.htm#CHDEJIJC">About Scheduled Links and Deferred Transactions</a></p> </li> <li> <p><a href="tdpii_reppit015.htm#CHDJHGAD">About Conflicts and Updatable Materialized Views</a></p> </li> </ul> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_reppit016.htm#BEHBDEHH">Configuring Replication of Read/Write Data Using Materialized Views</a></p> <p><a href="tdpii_adpit.htm#BABFHCBC">Administering a Materialized View Replication Environment</a></p> <p><a href="tdpii_reppit011.htm#BEHCEFGC">Replicating Read/Write Data Using Materialized Views</a></p> </div> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2007, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdpii_reppit011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_reppit013.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --></div> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de