CREATE_MASTER_REPOBJECT Procedure</tit le> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Language" content="EN"> <meta http-equiv="Content-Style-Type" content="text/css"> <meta http-equiv="Content-Script-Type" content="text/javascript"> <meta name="rob ots" content="all" scheme="http://www.robotstxt.org/"> <meta name="doctitle" content="Oracle® Database Advanced Replication Manag ement API Reference 10g Release 1 (10.1)"> <meta name="partno" content="B10733-01"> <meta name="docid" content="REPMA"> <link rel="St art" href="../../index.htm" title="Home" type="text/html"> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html"> <link rel="Stylesheet" href="../../dcommon/css/doccd.css" title="Default" type="text/css"> <link rel="Contents" hr ef="toc.htm" title="Contents" type="text/html"> <link rel="Index" href="index.htm" title="Index" type="text/html"> <link rel="Prev" h ref="rarrca26.htm" title="Previous" type="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next " href="rarrca28.htm" title="Next" type="text/html"> <link rel="alternate" href="../b10733.pdf" title="PDF version" type="application /pdf"> </head> <body> <div class="header"> <p><a name="top" id="top" href="#BEGIN">Skip Headers</a></p> <table summary="" cellspacing ="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><font color="#330099" face="Helvetica, Arial, sans-serif"><stro ng>Oracle® Database Advanced Replication Management API Reference<br> 10<i>g</i> Release 1 (10.1)</strong><br> Part Number B1073 3-01</font></td> <td valign="bottom" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="ce nter" 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/gifs/ 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</font></ 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="../../dcom mon/gifs/mix.gif" alt="Go to Master Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valig n="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> <hr> <table summary="layout table" cellspacing="0" cellpadd ing="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="rarrca26.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="rarrca28.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 align="right" valign="top"><a href="../b10733.pdf"><font size="-2">View PDF</font></a></td></tr></ta ble> <a name="BEGIN"></a></div> <div class="IND"> <a name="96329"></a> <h2 class="CM2"><a name="REPMA104"><font f ace="Arial, Helvetica, sans-serif" color="#330099">CREATE_MASTER_REPOBJECT Procedure</font></a></h2> <a name="96330"></a> <p class=" BP">This procedure makes an object a replicated object by adding the object to a master group. This procedure preserves the object id entifier for user-defined types and object tables at all replication sites.</p> <a name="96331"></a> <p class="BP">Replication of cl ustered tables is supported, but the <code>use_existing_object</code> parameter cannot be set to <code>false</code> for clustered tab les. In other words, you must create the clustered table at all master sites participating in the master group before you execute the <code>CREATE_MASTER_REPOBJECT</code> procedure. However, these tables do not need to contain the table data. So, the <code>copy_rows </code> parameter can be set to <code>true</code> for clustered tables.</p> <a name="96332"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Syntax</font></h3> <pre class="CE"><a name="96334"></a>DBMS_REPCAT.CREATE_MASTER_REPOBJECT ( < a name="96335"></a> sname IN VARCHAR2, <a name="96336"></a> oname IN VARCHAR2, <a name="96337" ></a> type IN VARCHAR2, <a name="96338"></a> use_existing_object IN BOOLEAN := true, <a name="96339"></ a> ddl_text IN VARCHAR2 := NULL, <a name="96340"></a> comment IN VARCHAR2 := '', <a name="96 341"></a> retry IN BOOLEAN := false, <a name="96342"></a> copy_rows IN BOOLEAN := true, <a name="96343"></a> gname IN VARCHAR2 := ''); </pre> <a name="96344"></a> <h3 class="CMS"><font face="Arial, Hel vetica, sans-serif" color="#330099">Parameters</font></h3> <a name="115424"></a> <p class="BP">The following table describes the par ameters for this procedure.</p> <h5 class="TT"><a name="118020"></a><a name="117171"></a> <strong><font face="Arial, Helvetica, sans- serif"><em>Table 18-54 CREATE_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="117175"></a> <font face="Arial, Helvetica, sans-serif"><strong >Parameters</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="117177"></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></thead> <tbody> <tr class="Formal" align="left" valign="top"> < td class="Formal"> <pre class="CEW"><a name="117179"></a>sname </pre> </td> <td class="Formal"><a name="117181"></a> <p class="TB">Na me of the schema in which the object that you want to replicate is located.</p></td></tr> <tr class="Formal" align="left" valign="top "> <td class="Formal"> <pre class="CEW"><a name="117183"></a>oname </pre> </td> <td class="Formal"><a name="117185"></a> <p class="TB ">Name of the object you are replicating. If <code>ddl_text</code> is <code>NULL</code>, then this object must already exist in the s pecified schema. To ensure uniqueness, table names should be a maximum of 27 bytes long, and package names should be no more than 24 bytes. The object 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="117187"></a>type </pre> </td> <td class="Formal"><a name="117189"></a> <p class="TB">Type of the object that you are replicating. The following types are supported:</p> <pre class="TCI"><a name="117190"></a>FUNCTION SYNONYM <a name="117191"></a>INDEX TABLE <a name="117192"></a>INDEXTYPE TRIGGER <a name="117193"></ a>OPERATOR TYPE <a name="117270"></a>PACKAGE TYPE BODY <a name="117271"></a>PACKAGE BODY VI EW <a name="117272"></a>PROCEDURE </pre> </td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CE W"><a name="117204"></a>use_existing_object </pre> </td> <td class="Formal"><a name="117206"></a> <p class="TB">Indicate <code>true</ code> if you want to reuse any objects of the same type and shape at the current master sites. See <a href="rarrca27.htm#96448">Table 18-56</a> for more information. <a name="117210"></a></p> <p class="TB"><strong class="Bold">Note:</strong> This parameter must be set to <code>true</code> for clustered tables.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <p re class="CEW"><a name="117212"></a>ddl_text </pre> </td> <td class="Formal"><a name="117214"></a> <p class="TB">If the object does n ot already exist at the master definition site, then you must supply the DDL text necessary to create this object. PL/SQL packages, p ackage bodies, procedures, and functions must have a trailing semicolon. SQL statements do not end with trailing semicolon. Oracle do es not parse this DDL before applying it; therefore, you must ensure that your DDL text provides the appropriate schema and object na me for the object being created. <a name="117215"></a></p> <p class="TB">If the DDL is supplied without specifying a schema (<code>sn ame</code> parameter), then the default schema is the replication administrator's schema. Be sure to specify the schema if it is othe r than the replication administrator's schema. <a name="117216"></a></p> <p class="TB"><strong class="Bold">Note:</strong> Do not use the <code>ddl_text</code> parameter to add user-defined types or object tables. Instead, create the object first and then add the ob ject.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117218"></a>comment < /pre> </td> <td class="Formal"><a name="117220"></a> <p class="TB">This comment is added to the <code>OBJECT_COMMENT</code> field of the <code>DBA_REPOBJECT</code> view.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW" ><a name="117222"></a>retry </pre> </td> <td class="Formal"><a name="117224"></a> <p class="TB">Indicate <code>true</code> if you wan t Oracle to reattempt to create an object that it was previously unable to create. Use this if the error was transient or has since b een rectified, or if you previously had insufficient resources. If this is <code>true</code>, then Oracle creates the object only at master sites whose object status is not <code>VALID</code>.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Fo rmal"> <pre class="CEW"><a name="117226"></a>copy_rows </pre> </td> <td class="Formal"><a name="117228"></a> <p class="TB">Indicate < code>true</code> if you want the initial contents of a newly replicated object to match the contents of the object at the master defi nition site. See <a href="rarrca27.htm#96448">Table 18-56</a> for more information.</p></td></tr> <tr class="Formal" align="left " valign="top"> <td class="Formal"> <pre class="CEW"><a name="117233"></a>gname </pre> </td> <td class="Formal"><a name="117235"></a> <p class="TB">Name of the replication group in which you want to create the replicated object. The schema name is used as the defaul t replication group name if none is specified, and a replication group with the same name as the schema must exist for the procedure to complete successfully in that case.</p></td></tr></tbody></table> <a name="115522"></a> <h3 class="CMS"><font face="Arial, Helvet ica, sans-serif" color="#330099">Exceptions</font></h3> <h5 class="TT"><a name="115578"></a><a name="115555"></a> <strong><font face= "Arial, Helvetica, sans-serif"><em>Table 18-55 CREATE_MASTER_REPOBJECT Procedure Exceptions </em></font></strong></h5> <table s ummary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <t head> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" scope="col"><a name="115559"></a> <font face="Arial, Helvet ica, sans-serif"><strong>Exceptions</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="115561" ></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></thead> <tbody> <tr class="Formal" alig n="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="115599"></a>nonmasterdef </pre> </td> <td class="Formal"><a name ="115601"></a> <p class="TB">Invocation site is not the master definition site.</p></td></tr> <tr class="Formal" align="left" valign= "top"> <td class="Formal"> <pre class="CEW"><a name="115603"></a>notquiesced </pre> </td> <td class="Formal"><a name="115605"></a> <p class="TB">Master group is not quiesced.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class= "CEW"><a name="115607"></a>duplicateobject </pre> </td> <td class="Formal"><a name="115609"></a> <p class="TB">Specified object alrea dy exists in the master group and retry is <code>false</code>, or if a name conflict occurs.</p></td></tr> <tr class="Formal" align=" left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="115611"></a>missingobject </pre> </td> <td class="Formal"><a name=" 115613"></a> <p class="TB">Object identified by <code>sname</code> and <code>oname</code> does not exist and appropriate DDL has not been provided.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="115615"></a> typefailure </pre> </td> <td class="Formal"><a name="115617"></a> <p class="TB">Objects of the specified type cannot be replicated.</ p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="115619"></a>ddlfailure </pre > </td> <td class="Formal"><a name="115621"></a> <p class="TB">DDL at the master definition site did not succeed.</p></td></tr> <tr c lass="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="115623"></a>commfailure </pre> </td> <td class ="Formal"><a name="115625"></a> <p class="TB">At least one master site is not accessible.</p></td></tr></tbody></table> <a name="1153 61"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Object Creations</font></h3> <h5 class="TT"><a na me="96505"></a><a name="96448"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-56 Object Creation at Master Sites </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 na me="96456"></a> <font face="Arial, Helvetica, sans-serif"><strong>Object</strong></font> <a name="96457"></a> <font face="Arial, Helv etica, sans-serif"><strong>Already</strong></font> <a name="96458"></a> <font face="Arial, Helvetica, sans-serif"><strong>Exists?</st rong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="96460"></a> <font face="Arial, Helvetica, sans -serif"><strong>COPY_ROWS</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="96462"></a> <font face="Arial, Helvetica, sans-serif"><strong>USE_EXISTING_<br> OBJECTS</strong></font></th> <th class="Formal" align="left" valign="b ottom" scope="col"><a name="96464"></a> <font face="Arial, Helvetica, sans-serif"><strong>Result</strong></font></th></tr></thead> <t body> <tr class="Formal" align="left" valign="top"> <td class="Formal"><a name="96466"></a> <p class="TB">yes</p></td> <td class="Fo rmal"> <pre class="CEW"><a name="96468"></a>true </pre> </td> <td class="Formal"> <pre class="CEW"><a name="96470"></a>true </pre> </ td> <td class="Formal"><a name="96472"></a> <p class="TB"><code>duplicatedobject</code> message if objects do not match. For tables, use data from master definition site.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"><a name="96474"> </a> <p class="TB">yes</p></td> <td class="Formal"> <pre class="CEW"><a name="96476"></a>false </pre> </td> <td class="Formal"> <pre class="CEW"><a name="96478"></a>true </pre> </td> <td class="Formal"><a name="96480"></a> <p class="TB"><code>duplicatedobject</code > message if objects do not match. For tables, DBA must ensure contents are identical.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"><a name="96482"></a> <p class="TB">yes</p></td> <td class="Formal"> <pre class="CEW"><a name="96484 "></a>true/false </pre> </td> <td class="Formal"> <pre class="CEW"><a name="96486"></a>false </pre> </td> <td class="Formal"><a name= "96488"></a> <p class="TB"><code>duplicatedobject</code> message.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td cla ss="Formal"><a name="96490"></a> <p class="TB">no</p></td> <td class="Formal"> <pre class="CEW"><a name="96492"></a>true </pre> </td > <td class="Formal"> <pre class="CEW"><a name="96494"></a>true/false </pre> </td> <td class="Formal"><a name="96496"></a> <p class=" TB">Object is created. Tables populated using data from master definition site.</p></td></tr> <tr class="Formal" align="left" valign= "top"> <td class="Formal"><a name="96498"></a> <p class="TB">no</p></td> <td class="Formal"> <pre class="CEW"><a name="96500"></a>fa lse </pre> </td> <td class="Formal"> <pre class="CEW"><a name="96502"></a>true/false </pre> </td> <td class="Formal"><a name="96504"> </a> <p class="TB">Object is created. DBA must populate tables and ensure consistency of tables at all sites.</p></td></tr></tbody></ table></div> <div class="footer"> <hr> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td style="width: 33%;" a lign="left"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center" valign=" top"><a href="rarrca26.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size="-2">Previo us</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="rarrca28.htm"><img src="../../d common/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 Reserved.</font></td> <td style="width: 3 3%;" 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/gifs/bookicon.gif" alt="Go to Book Li st" border="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcomm on/gifs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valig n="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 Mas ter Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../../dcommon/h tml/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>