ALTER_MASTER_REPOBJECT Procedure</titl e> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Language" content="EN"> <meta h ttp-equiv="Content-Style-Type" content="text/css"> <meta http-equiv="Content-Script-Type" content="text/javascript"> <meta name="robo ts" content="all" scheme="http://www.robotstxt.org/"> <meta name="doctitle" content="Oracle® Database Advanced Replication Manage ment API Reference 10g Release 1 (10.1)"> <meta name="partno" content="B10733-01"> <link rel="Start" href="../../index.htm" title="Ho me" type="text/html"> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html"> <link rel="Stylesh eet" href="../../dcommon/css/doccd.css" title="Default" type="text/css"> <link rel="Contents" href="toc.htm" title="Contents" type="t ext/html"> <link rel="Index" href="index.htm" title="Index" type="text/html"> <link rel="Prev" href="rarrcat9.htm" title="Previous" t ype="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next" href="rarrca11.htm" title="Next" ty pe="text/html"> <link rel="alternate" href="../b10733.pdf" title="PDF version" type="application/pdf"> </head> <body> <div class="hea der"> <p><a name="top" id="top" href="#BEGIN">Skip Headers</a></p> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <t r> <td align="left" valign="top"><font color="#330099" face="Helvetica, Arial, sans-serif"><strong>Oracle® Database Advanced Repl ication Management API Reference<br> 10<i>g</i> Release 1 (10.1)</strong><br> Part Number B10733-01</font></td> <td valign="bottom" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href="../../ind ex.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home</font></a></td > <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/gifs/bookicon.gif" alt="Go to Book List" b order="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcommon/gi fs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valign="to p"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0"><br> <font size="-2">Index</font></a>< /td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gifs/mix.gif" alt="Go to Master I ndex" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../../dcommon/html/f eedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback</font></a> </td></tr></table></td></tr></table> <hr> <table summary="layout table" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align= "left" valign="top"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center" valign="top"><a href="rarrcat9.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size="-2 ">Previous</font></a></td> <td align="center" valign="top"><a href="rarrcatp.htm"><img src="../../dcommon/gifs/uarrow.gif" alt="Go to current chapter" border="0"><br> <font size="-2">Up</font></a></td> <td align="center" valign="top"><a href="rarrca11.htm"><img src= "../../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td></tr></table></td> <td alig n="right" valign="top"><a href="../b10733.pdf"><font size="-2">View PDF</font></a></td></tr></table> <a name="BEGIN"></a></div> <div class="IND"> <a name="95098"></a> <h2 class="CM2"><font face="Arial, Helvetica, sans-serif" color="#330099">ALTER _MASTER_REPOBJECT Procedure</font></h2> <a name="95099"></a> <p class="BP">This procedure alters an object in your replication envir onment. You must call this procedure from the master definition site.</p> <a name="110406"></a> <p class="BP">This procedure require s that you quiesce the master group of the object if either of the following conditions is true:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="110407"></a>You are altering a table in a multimaster replication environment.</li> <li class="LB1" type="disc" ><a name="110408"></a>You are altering a table with the <code>safe_table_change</code> parameter set to <code>false</code> in a singl e master replication environment.</li></ul> <a name="110409"></a> <p class="BP">You can use this procedure to alter nontable objects without quiescing the master group.</p> <a name="95100"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#3300 99">Syntax</font></h3> <pre class="CE"><a name="95102"></a>DBMS_REPCAT.ALTER_MASTER_REPOBJECT ( <a name="95103"></a> sname IN VARCHAR2, <a name="95104"></a> oname IN VARCHAR2, <a name="95105"></a> type IN VARC HAR2, <a name="95106"></a> ddl_text IN VARCHAR2, <a name="95107"></a> comment IN VARCHAR2 := '', <a name="95108"></a> retry IN BOOLEAN := false <a name="117944"></a> safe_table_change IN BOOLEAN := false); </pre> <a name="117945"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Parameters</font> </h3> <h5 class="TT"><a name="118012"></a><a name="117952"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-19 ALT ER_MASTER_REPOBJECT Procedure Parameters </em></font></strong></h5> <table summary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align= "left" valign="bottom" scope="col"><a name="117956"></a> <font face="Arial, Helvetica, sans-serif"><strong>Parameter</strong></font>< /th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="117958"></a> <font face="Arial, Helvetica, sans-serif"><str ong>Description</strong></font></th></tr></thead> <tbody> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre clas s="CEW"><a name="117960"></a>sname </pre> </td> <td class="Formal"><a name="117962"></a> <p class="TB">Schema containing the object t hat you want to alter.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="1179 64"></a>oname </pre> </td> <td class="Formal"><a name="117966"></a> <p class="TB">Name of the object that you want to alter. The obje ct cannot be a storage table for a nested table.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117968"></a>type </pre> </td> <td class="Formal"><a name="117970"></a> <p class="TB">Type of the object that yo u are altering. The following types are supported:</p> <pre class="TCI"><a name="117971"></a>FUNCTION SYNONYM <a name=" 117972"></a>INDEX TABLE <a name="117973"></a>INDEXTYPE TRIGGER <a name="117974"></a>OPERATOR TYPE <a name="117975"></a>PACKAGE TYPE BODY <a name="117976"></a>PACKAGE BODY VIEW <a name="117977"></a> PROCEDURE </pre> </td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117979"></a> ddl_text </pre> </td> <td class="Formal"><a name="117981"></a> <p class="TB">The DDL text that you want used to alter the object. Ora cle does not parse this DDL before applying it. Therefore, you must ensure that your DDL text provides the appropriate schema and obj ect name for the object being altered. <a name="117982"></a></p> <p class="TB">If the DDL is supplied without specifying a schema, th en the default schema is the replication administrator's schema. Be sure to specify the schema if it is other than the replication ad ministrator's schema.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="11798 4"></a>comment </pre> </td> <td class="Formal"><a name="117986"></a> <p class="TB">If not <code>NULL</code>, then this comment is add ed to the <code>COMMENT</code> field of the <code>DBA_REPOBJECT</code> view.</p></td></tr> <tr class="Formal" align="left" valign="to p"> <td class="Formal"> <pre class="CEW"><a name="117988"></a>retry </pre> </td> <td class="Formal"><a name="117990"></a> <p class="T B">If retry is <code>true</code>, then <code>ALTER_MASTER_REPOBJECT</code> alters the object only at masters whose object status is n ot <code>VALID</code>.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="1179 93"></a>safe_table_change </pre> </td> <td class="Formal"><a name="117995"></a> <p class="TB">Specify <code>true</code> if the change to a table is safe. Specify <code>false</code> if the change to a table is unsafe. <a name="117996"></a></p> <p class="TB">You can m ake safe changes to a master table in a single master replication environment without quiescing the master group that contains the ta ble. To make unsafe changes, you must quiesce the master group. <a name="117997"></a></p> <p class="TB">Only specify this parameter f or tables in single master replication environments. This parameter is ignored in multimaster replication environments and when the o bject specified is not a table. In multimaster replication environments, you must quiesce the master group to run the <code>ALTER_MAS TER_REPOBJECT</code> procedure on a table. <a name="117998"></a></p> <p class="TB">The following are safe changes:</p> <ul class="TLB "> <li class="TLB" type="disc"><a name="117999"></a>Changing storage and extent information</li> <li class="TLB" type="disc"><a name= "118000"></a>Making existing columns larger. For example, changing a <code>VARCHAR2(20)</code> column to a <code>VARCHAR2(50)</code> column.</li> <li class="TLB" type="disc"><a name="118001"></a>Adding non primary key constraints</li> <li class="TLB" type="disc"><a name="118002"></a>Altering non primary key constraints</li> <li class="TLB" type="disc"><a name="118003"></a>Enabling and disabling n on primary key constraints</li></ul> <a name="118004"></a> <p class="TB">The following are unsafe changes:</p> <ul class="TLB"> <li class="TLB" type="disc"><a name="118005"></a>Changing the primary key by adding or deleting columns in the key</li> <li class="TLB" t ype="disc"><a name="118006"></a>Adding or deleting columns</li> <li class="TLB" type="disc"><a name="118007"></a>Making existing colu mns smaller. For example, changing a <code>VARCHAR2(50)</code> column to a <code>VARCHAR2(20)</code> column.</li> <li class="TLB" typ e="disc"><a name="118008"></a>Disabling a primary key constraint</li> <li class="TLB" type="disc"><a name="118009"></a>Changing the d atatype of an existing column</li> <li class="TLB" type="disc"><a name="118010"></a>Dropping an existing column</li></ul> <a name="11 8011"></a> <p class="TB">If you are unsure whether a change is safe or unsafe, then quiesce the master group before you run the <cod e>ALTER_MASTER_REPOBJECT</code> procedure.</p></td></tr></tbody></table> <a name="106730"></a> <h3 class="CMS"><font face="Arial, He lvetica, sans-serif" color="#330099">Exceptions</font></h3> <h5 class="TT"><a name="106775"></a><a name="106734"></a> <strong><font f ace="Arial, Helvetica, sans-serif"><em>Table 18-20 ALTER_MASTER_REPOBJECT Procedure Exceptions </em></font></strong></h5> <tabl e summary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" scope="col"><a name="106738"></a> <font face="Arial, Hel vetica, sans-serif"><strong>Exception</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="10674 0"></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></thead> <tbody> <tr class="Formal" al ign="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="106742"></a>nonmasterdef </pre> </td> <td class="Formal"><a na me="106744"></a> <p class="TB">Invocation site is not the master definition site.</p></td></tr> <tr class="Formal" align="left" valig n="top"> <td class="Formal"> <pre class="CEW"><a name="106746"></a>notquiesced </pre> </td> <td class="Formal"><a name="106748"></a> <p class="TB">Associated replication group has not been suspended.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td cl ass="Formal"> <pre class="CEW"><a name="106750"></a>missingobject </pre> </td> <td class="Formal"><a name="106752"></a> <p class="TB" >Object identified by <code>sname</code> and <code>oname</code> does not exist.</p></td></tr> <tr class="Formal" align="left" valign= "top"> <td class="Formal"> <pre class="CEW"><a name="106754"></a>typefailure </pre> </td> <td class="Formal"><a name="106756"></a> <p class="TB">Specified type parameter is not supported.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal" > <pre class="CEW"><a name="106758"></a>ddlfailure </pre> </td> <td class="Formal"><a name="106760"></a> <p class="TB">DDL at the mas ter definition site did not succeed.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW" ><a name="106762"></a>commfailure </pre> </td> <td class="Formal"><a name="106764"></a> <p class="TB">At least one master site is not accessible.</p></td></tr></tbody></table></div> <div class="footer"> <hr> <table summary="" cellspacing="0" cellpadding="0" width="1 00%"> <tr> <td style="width: 33%;" align="left"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="13 5"> <tr> <td align="center" valign="top"><a href="rarrcat9.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" bo rder="0"><br> <font size="-2">Previous</font></a></td> <td align="center" valign="top"><a href="rarrcatp.htm"><img src="../../dcommon /gifs/uarrow.gif" alt="Go to current chapter" border="0"><br> <font size="-2">Up</font></a></td> <td align="center" valign="top"><a h ref="rarrca11.htm"><img src="../../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td ></tr></table></td> <td style="width: 34%;" align="center"><img src="../../dcommon/gifs/oracle.gif" alt="Oracle"><br> <a href="../../ dcommon/html/cpyr.htm"><font size="-2">Copyright © 1996, 2003 Oracle Corporation</font></a><br> <font size="-2">All Rights Reser ved.</font></td> <td style="width: 33%;" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align ="center" valign="top"><a href="../../index.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0" ><br> <font size="-2">Home</font></a></td> <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/g ifs/bookicon.gif" alt="Go to Book List" border="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcommon/gifs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</fon t></a></td> <td align="center" valign="top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border=" 0"><br> <font size="-2">Index</font></a></td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../ dcommon/gifs/mix.gif" alt="Go to Master Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" v align="top"><a href="../../dcommon/html/feedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0" ><br> <font size="-2">Feedback</font></a></td></tr></table></td></tr></table></div> </body> </html>