Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\multimaster014.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>Altering Objects in a Master Group</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="Altering Objects in a Master Group" /> <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="multimaster013.htm" title="Previous" type="text/html" /> <link rel="next" href="multimaster015.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="multimaster013.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster015.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BGBHEIIB" name="BGBHEIIB"></a><a id="ADVRP184" name="ADVRP184"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Altering Objects in a Master Group</h1> <p>To alter the definition of a replication object in a master group, you should always use Oracle Enterprise Manager (or an equivalent replication management API call). Use of other Enterprise Manager tools or a <code>SQL DDL</code> command in SQL*Plus (for example, <code>ALTER TABLE</code>) to directly alter an object in a replicated environment does not necessarily propagate DDL changes to the object at all sites in the system.</p> <p>Consider the following issues before and after altering a replicated object in a master group:</p> <ul> <li> <p>When you alter a replicated table that has dependent updatable materialized views, it may be necessary to first push all changes from the materialized view site.</p> </li> <li> <p>After altering a replicated object, you must regenerate replication support for the object.</p> </li> <li> <p>After altering a replicated object, check the administrative requests at the master definition site to be sure that the object was successfully modified at each master site. The DDL changes to the object and any supporting objects are asynchronously applied at each master site.</p> </li> <li> <p>After altering a replicated table that has dependent materialized views, you must drop and recreate the materialized views in order to reflect this change at the materialized view sites. All other replicated objects at a materialized view site would be automatically recreated the next time that a dependent materialized view is refreshed.</p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span>Local customization of individual replicas at materialized view or master sites is outside the scope of Oracle Replication. As a replication administrator, you must ensure that local customizations do not interfere with any global customizations done with Oracle Enterprise Manager.</p> </div> <p>If you are using Oracle Enterprise Manager to alter an object, then, after successfully <a href="multimaster019.htm#BGBBJCDC">Suspending Replication Activity for a Master Group</a>, complete the following steps to alter the definition of an object in the group:</p> <ol> <li> <p>In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.</p> </li> <li> <p>Click <span class="bold">Data Movement</span>.</p> </li> <li> <p>Under the Advanced Replication section, click <span class="bold">Manage</span>.</p> <p>The Administration Overview page appears.</p> </li> <li> <p>Under the Multimaster Replication section, click the number link next to <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('MASTER_GROUPS');">Master Groups</a>.</p> <p>The Master Groups page appears.</p> </li> <li> <p>Select the target master group that contains the object for which you want to execute the DDL and click the number in the <span class="bold">Replicated Object</span> column.</p> <p>The Replicated Objects page appears.</p> </li> <li> <p>Select the object for which you want to execute the DDL 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 to be executed in the Enter DDL Text field.</p> <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> <p>After you alter the object, generate replication support the object (<a href="multimaster016.htm#BGBFEEAD">Generating Replication Support for Master Group Objects</a>), optionally apply the administrative requests (<a href="administer004.htm#BABDJHFG">Applying Administrative Requests</a>) that result from your changes at all master sites, and then resume replication activity for the master group (<a href="multimaster020.htm#BGBDGFIB">Resuming Replication Activity for a Master Group</a>).</p> <div class="helpinfonote"> <p><span class="bold">API Equivalent: </span><code>DBMS_REPCAT.ALTER_MASTER_REPOBJECT</code></p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="multimaster011.htm#BGBBFBGJ">Managing Master Groups</a></p> <p><a href="basic_concepts007.htm#BABIFJCG">What Is Multimaster Replication?</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="multimaster013.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster015.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