Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\multimaster035.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>Replicating Table Data to Master Sites</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="Replicating Table Data to Master Sites" /> <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="multimaster034.htm" title="Previous" type="text/html" /> <link rel="next" href="materialized.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="multimaster034.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BGBFDJIJ" name="BGBFDJIJ"></a><a id="ADVRP207" name="ADVRP207"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Replicating Table Data to Master Sites</h1> <p>When you add a table to a master group, the <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('MASTER_GROUP_CREATE');">Create Master Group</a> Wizard presents the Copy Row Data option.</p> <a id="ADVRP395" name="ADVRP395"></a> <p class="subhead2">Allowing Oracle to Replicate Table Data</p> <p>By default, when you add a table to a master group at the master definition site, Oracle replicates the data of the master definition site table to the table at all master sites. This option requires less administrative work but creates network traffic due to data copying.</p> <ul> <li> <p>If the replicated table at other sites is not populated with data, then enable the <span class="bold">Copy Row Data</span> option.</p> </li> <li> <p>If the replicated table at other sites is already populated with data, then disable the <span class="bold">Copy Row Data</span> option, because enabling the option causes the data to be reloaded.</p> </li> </ul> <a id="ADVRP396" name="ADVRP396"></a> <p class="subhead2">Manually Loading Table Data</p> <p>Before adding a table to a group at the master definition site, you can precreate an identical table structure at each master site and then manually load identical data into each table replica. Later, when you add the object to the group at the master definition site, Oracle can use the existing table replicas and forego creating and replicating table data at each master site. This option is appropriate when you are configuring large tables and want to minimize the network traffic due to initial object creation and data replication. If you precreate the table and populate it with data, then disable the <span class="bold">Copy Row Data</span> option.</p> <p>When you choose to populate a replicated table at a master site yourself, you are responsible for ensuring that the table data is consistent among all replicas in the system. For example, when manually populating replicated tables with data, do so before adding the table to its master group. Also, prevent applications from accessing the replicated table until the table is added to a master group and replication activity is resumed. Otherwise, the table might become inconsistent at the various master sites.</p> <a id="ADVRP397" name="ADVRP397"></a> <p class="subhead2">Offline Instantiation</p> <p>If you are currently replicating a large amount of data and want to add a new site to the system, you should consider offline instantiation.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>See <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPMA007','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication Management API Reference</span></a> for complete information about adding new master sites using offline instantiation.</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="multimaster011.htm#BGBBFBGJ">Managing Master Groups</a></p> </div> </div> <!-- class="sect2" --> <!-- 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="multimaster034.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized.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