Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\basic_concepts012.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>Updatable Materialized Views</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-23T10:13:5Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Updatable Materialized Views" /> <meta name="relnum" content="11g Release 1 (11.1)" /> <meta name="partnum" content="A12345-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="basic_concepts011.htm" title="Previous" type="text/html" /> <link rel="next" href="basic_concepts013.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> <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="basic_concepts011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="basic_concepts013.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDBDGBB" name="CHDBDGBB"></a><a id="ADVRP117" name="ADVRP117"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Updatable Materialized Views</h1> <p>In a more advanced configuration, you can create an <span class="italic">updatable materialized view</span> that allows users to insert, update, and delete rows of the target master by performing these operations on the materialized view. An updatable materialized view may also contain a subset of the data in the target master.</p> <p>Updatable materialized views are based on tables or other materialized views that have been set up to support replication. In fact, updatable materialized views must be part of a materialized view group that is based on another replication group.</p> <p>Updatable materialized views have the following properties.</p> <ul> <li> <p>They are always based on a single table, although multiple tables can be referenced in a subquery.</p> </li> <li> <p>They can be incrementally (or fast) refreshed.</p> </li> <li> <p>Oracle propagates the changes made to an updatable materialized view to the materialized view's remote master. The updates to the master then cascade to all other master sites.</p> </li> </ul> <p>Updatable materialized views provide the following benefits:</p> <ul> <li> <p>Allow users to query and update a local replicated data set even when disconnected from the master.</p> </li> <li> <p>Require fewer resources than multimaster replication, while still supporting data updates. Materialized views can reduce the amount of stress placed on network resources because materialized views can be refreshed on demand, while multimaster replication propagates changes at regular intervals. In addition, because materialized views can reside in a database that contains far less data, the disk space and memory requirements for materialized view clients can be less than the requirements for an Oracle server containing master sites.</p> </li> </ul> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="getting_started002.htm#CHDFHHJC">Flowchart for Creating a Replication Environment</a></p> <p><a href="basic_concepts010.htm#CHDIEEDI">What Is Materialized View Replication?</a></p> <p><a href="basic_concepts002.htm#CHDJBCJB">Replication Objects</a></p> <p><a href="basic_concepts003.htm#CHDBCJIJ">Replication Groups</a></p> <p><a href="basic_concepts004.htm#CHDEBEFC">Replication Sites</a></p> </div> </div> <!-- class="sect3" --> <!-- 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 © 2005, 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="basic_concepts011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="basic_concepts013.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de