Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\multimaster034.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>Manually Creating Objects</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="Manually Creating Objects" /> <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="multimaster033.htm" title="Previous" type="text/html" /> <link rel="next" href="multimaster035.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="multimaster033.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster035.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDEIAIJ" name="CHDEIAIJ"></a><a id="ADVRP206" name="ADVRP206"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Manually Creating Objects</h1> <p>Before adding an object to a group at the master definition site, you can manually create an identical object definition at each master site. Later, when you add the object to the group, Oracle can use the existing objects and avoid creating the object at each master site.</p> <p>If the replicated object exists at other sites, then enable the <span class="bold">Use Existing Object</span> option. In this case, Oracle uses the existing objects at the master sites and does not create new objects. However, if you enable the <span class="bold">Use Existing Object</span> option and the object does not exist at the other master sites, Oracle creates the object automatically.</p> <p>Manual creation of replication objects can help to minimize network traffic when you are configuring large replication environments. You might also want to consider this option when a master group contains tables with circular dependencies or a specific table contains a self-referential constraint.</p> <p>When you choose to precreate replication objects, consider the following issues.</p> <ul> <li> <p>When you choose to precreate a replicated table yourself, you are responsible for ensuring that the shape of the table (number, names, and data types of all table columns) is identical at all sites. Oracle raises an exception when a table at a master site is not the same shape as the table at the master definition site.</p> </li> <li> <p>When you choose to precreate a non-table replication object yourself, you are responsible for ensuring that the SQL definition of the object is identical at all sites. Oracle raises an exception when an object at a master site does not have the same SQL definition as the object at the master definition site.</p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span>Replication of clustered tables is supported, but you must manually precreate the clustered table at each master site and enable the <span class="bold">Use Existing Object</span> option for these tables.</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="multimaster011.htm#BGBBFBGJ">Managing Master Groups</a></p> </div> </div> <!-- class="sect3" --> <!-- class="sect2" --> <!-- 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="multimaster033.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster035.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