Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\configure025.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>Add Site Column to Table: Step 1</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-23T10:13:6Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Add Site Column to Table: Step 1" /> <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="configure024.htm" title="Previous" type="text/html" /> <link rel="next" href="configure026.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="configure024.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="configure026.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CACIFHEE" name="CACIFHEE"></a><a id="ADVRP312" name="ADVRP312"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Add Site Column to Table: Step 1</h1> <p>If the target table does not already contain a site column, then you need to add an additional column to your table to record the site's value when a row is inserted or updated. Additionally, you must use the Alter Object subpage of the replicated object property sheet to apply the DDL to the target table. Simply issuing the DDL in SQL*Plus (or equivalent tool) may cause the replicated object to become invalid. If you prefer to use SQL*Plus to make such an alteration, make sure that you use the <code>ALTER_MASTER_REPOBJECT</code> procedure to execute the DDL.</p> <p>Complete the following steps to add a site column to the table:</p> <ol> <li> <p>Complete the steps in <a href="configure008.htm#CACIECGJ">Before Configuring Conflict Resolution</a>.</p> </li> <li> <p>Select the table for which you want to add the conflict resolution method and click <span class="bold">Edit</span>.</p> <p>The General subpage of the Edit Replicated Object page appears.</p> </li> <li> <p>Click <span class="bold">Advanced</span> to display the Enter DDL Text field.</p> </li> <li> <p>Enter the DDL in the Enter DDL Text field to add a site column to the selected table.</p> <p>For example, to add a site column named <code>SITE_PRIORITY</code> to a table named <code>ORDERS</code> in the <code>OE</code> schema, enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> ALTER TABLE oe.orders ADD (site_priority VARCHAR2(20)) </pre> <div class="helpinfonote"> <p><span class="bold">Note: </span>Do not include the terminating semi-colon (<code>;</code>) at the end of the DDL statement.</p> </div> </li> <li> <p>Click <span class="bold">Apply</span> to execute the specified DDL at the selected master group.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="configure001.htm#CACJABIJ">About Conflict Resolution Methods</a></p> </div> </div> <!-- 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="configure024.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="configure026.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