Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\multimaster028.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>Executing DDL Within 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="Executing DDL Within 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="multimaster027.htm" title="Previous" type="text/html" /> <link rel="next" href="multimaster029.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="multimaster027.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster029.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BGBDGGBD" name="BGBDGGBD"></a><a id="ADVRP199" name="ADVRP199"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Executing DDL Within a Master Group</h1> <p>Oracle Enterprise Manager lets you propagate one or more SQL DDL statements to some or all of the master sites in a master group. This option lets you execute unique DDL that is not specifically supported within Oracle's replication management API. For example:</p> <ul> <li> <p>You might want to create supporting objects for a replicated environment. For example, you might want to coordinate the creation of sequences with the same name at each master site to support a replicated table's primary key such that uniqueness conflicts are not possible. Specifically, at each site in a shared data ownership system, you can create sequences so that each sequence generates a mutually exclusive set of sequence numbers.</p> </li> <li> <p>You might want to perform security management related to the replicated environment. For example, you might want to grant the privileges necessary to access replicas of a table throughout a multimaster system.</p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Caution: </span>Do not execute DDL that could damage global database integrity in a multimaster environment. Also, 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 other sites in the system.</p> </div> <p>Consider the following issues before and after executing the DDL:</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>To execute DDL at selected master sites in a master 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> to open the Master Groups page.</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> <div class="helpinfonote"> <p><span class="bold">API Equivalent: </span><code>DBMS_REPCAT.EXECUTE_DDL</code></p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="basic_concepts025.htm#CHDGDHCG">Distributed Schema Management</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="multimaster027.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="multimaster029.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