Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_reppit005.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>Preparing for Materialized View Replication</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="Preparing for Materialized View Replication" /> <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_reppit004.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_reppit006.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_reppit004.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_reppit006.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDIHIFJ" name="CHDIHIFJ"></a><a id="TDPII102" name="TDPII102"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Preparing for Materialized View Replication<a id="sthref407" name="sthref407"></a><a id="sthref408" name="sthref408"></a><a id="sthref409" name="sthref409"></a><a id="sthref410" name="sthref410"></a><a id="sthref411" name="sthref411"></a><a id="sthref412" name="sthref412"></a><a id="sthref413" name="sthref413"></a><a id="sthref414" name="sthref414"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>Before configuring materialized view replication, prepare the databases that will participate in the replication environment.</p> <p class="orderedlisttitle">To prepare for materialized view replication: </p> <ol> <li> <p>If possible, then ensure that each replicated table has a primary key. Where a primary key is not possible, each replicated table must have a column or set of columns that can be used as a unique identifier for each row of the table. If the tables that you plan to use in your replication environment do not have a primary key or a set of unique columns, then alter these tables accordingly.</p> </li> <li> <p>Set initialization parameters properly at each database in your replication environment before you configure materialized view replication:</p> <ul> <li> <p><span class="bold">Global names:</span> Set the <code>GLOBAL_NAMES</code> initialization parameter to <code>TRUE</code> at each database that will participate in the replication environment. See <a href="tdpii_common_ii001.htm#BGBEEDCD">"Setting the GLOBAL_NAMES Initialization Parameter to TRUE"</a>.</p> </li> <li> <p><span class="bold">System Global Area (SGA) and the shared pool:</span> Ensure that the shared pool is large enough to accommodate the components created for the replication environment. The shared pool is part of the SGA. You can manage the shared pool by setting the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN10285','newWindow').focus()"><code>MEMORY_TARGET</code></a> initialization parameter (Automatic Memory Management), the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN10256','newWindow').focus()"><code>SGA_TARGET</code></a> initialization parameter (Automatic Shared Memory Management), or the <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REFRN10202','newWindow').focus()"><code>SHARED_POOL_SIZE</code></a> initialization parameter. Typically, the shared pool should be larger for an Oracle database in a replication environment than in a nonreplication environment.</p> </li> </ul> <p>See <a href="topicid:ADMQS053">Viewing and Modifying Initialization Parameters</a> for information about modifying initialization parameters.</p> </li> <li> <p>Configure network connectivity so that the databases in the replication environment can communicate with each other. See <a href="topicid:ADMQS004">Configuring the Network Environment</a> for information about configuring network connectivity between databases.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_reppit008.htm#BEHDACAG">Replicating Read-Only Data Using Materialized Views</a></p> <p><a href="tdpii_reppit011.htm#BEHCEFGC">Replicating Read/Write Data Using Materialized Views</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPLN104','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication</span></a> for more information about initialization parameters in a replication environment</p> <p><a href="tdpii_reppit.htm#BEHHGGIB">Replicating Data Using Materialized Views</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 © 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_reppit004.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_reppit006.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