Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\materialized001.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>Before Creating 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="Before Creating 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="materialized.htm" title="Previous" type="text/html" /> <link rel="next" href="materialized002.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="materialized.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized002.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHIGJDI" name="CIHIGJDI"></a><a id="ADVRP209" name="ADVRP209"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Before Creating Materialized Views</h1> <p>A materialized view is a replica of a target master table from a single point-in-time. Whereas in multi master replication tables are continuously being updated by other master sites, materialized views are updated by one or more master tables through individual batch updates, known as refreshes, from a single master site.</p> <p>A materialized view group maintains a partial or complete copy of the objects at the target master group. Materialized View groups cannot span across master group boundaries.</p> <p>Before you create a materialized view group, complete the following tasks:</p> <ul> <li> <p>See <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPLN003','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication</span></a> for more information. Understanding the concepts behind materialized views will better prepare you to create them.</p> </li> <li> <p>Create a materialized view log for each master table that will support materialized view sites. A materialized view log is required for materialized views to perform fast refreshes with the master table. See <a href="materialized002.htm#BEIHCICE">Creating Materialized View Logs</a> for instructions.</p> </li> <li> <p>If conflicts are possible at the master site because of activity at the materialized view sites you are creating, configure conflict resolution for the master tables of the materialized views before you create the materialized views. See <a href="configure001.htm#CACJABIJ">About Conflict Resolution Methods</a> for more information about configuring conflict resolution.</p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span>If you plan to define conflict resolution methods or use column subsetting for materialized views you create, you must first quiesce the master group containing the objects. Also, column-subsetted materialized views are available only when using the Deployment Template Wizard.</p> </div> <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> </div> </div> <!-- class="sect1" --> <!-- 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="materialized.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized002.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