Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\multimaster030.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>Designating an Alternate Key for a Replicated Table</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="Designating an Alternate Key for a Replicated Table" /> <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="multimaster029.htm" title="Previous" type="text/html" /> <link rel="next" href="multimaster031.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="multimaster029.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster031.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BGBDHHDA" name="BGBDHHDA"></a><a id="ADVRP202" name="ADVRP202"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Designating an Alternate Key for a Replicated Table</h1> <p>Oracle must be able to uniquely identify and match corresponding rows at different sites during data replication. Typically, Oracle replication uses the primary key of a table to uniquely identify rows in the table. When a table does not have a primary key, you must designate an alternate key. This alternate key can be a column or set of columns that Oracle can use to uniquely identify rows in the table during data replication.</p> <div class="helpinfonote"> <p><span class="bold">Caution: </span>To ensure that Oracle can identify rows and preserve the integrity of replicated data, applications should not be allowed to update the identity columns of a table.</p> </div> <p>When you create a new master group that has a table that does not have a primary key, or attempt to add a table that does not have a primary key to a master group, the Create Master Group Wizard automatically displays the Set Alternate Key Columns page so that you can identify an alternate identity column or set of columns for the replicated table.</p> <div class="helpinfonote"> <p><span class="bold">API Equivalent: </span><code>DBMS_REPCAT.SET_COLUMNS</code></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="multimaster029.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster031.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