CREATE_MVIEW_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="rarrca28.htm" title="Previous" t ype="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next" href="rarrca30.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="rarrca28.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="rarrca30.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="107162"></a> <h2 class="CM2"><font face="Arial, Helvetica, sans-serif" color="#330099">CREA TE_MVIEW_REPOBJECT Procedure</font></h2> <a name="107163"></a> <p class="BP">This procedure adds a replicated object to a materializ ed view group.</p> <a name="107164"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Syntax</font></h3 > <pre class="CE"><a name="107166"></a>DBMS_REPCAT.CREATE_MVIEW_REPOBJECT ( <a name="107167"></a> sname IN VARC HAR2, <a name="107168"></a> oname IN VARCHAR2, <a name="107169"></a> type IN VARCHAR2, <a name="107170"></a> ddl_text IN VARCHAR2 := '', <a name="107171"></a> comment IN VARCHAR2 := '', <a name="107172"></a> gname IN VARCHAR2 := '', <a name="107173"></a> gen_objs_owner IN VA RCHAR2 := '', <a name="107174"></a> min_communication IN BOOLEAN := true, <a name="107175"></a> generate_80_compatible IN BOOLEAN := true, <a name="119047"></a> gowner IN VARCHAR2 := 'PUBLIC'); </pre> <a name="107177"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Parameters</font></h3> <h5 class="TT"><a name="109081"></a> <a name="117325"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-59 CREATE_MVIEW_REPOBJECT Procedure Parameters & nbsp;</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 ="117329"></a> <font face="Arial, Helvetica, sans-serif"><strong>Parameter</strong></font></th> <th class="Formal" align="left" valig n="bottom" scope="col"><a name="117331"></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="117333"></a>sname </pre> </td> <td class="Formal"><a name="117335"></a> <p class="TB">Name of the schema in which the object is located. The schema must be sa me as the schema that owns the master table or master materialized view on which this materialized view is based.</p></td></tr> <tr c lass="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117337"></a>oname </pre> </td> <td class="Form al"><a name="117339"></a> <p class="TB">Name of the object that you want to add to the replicated materialized view group.</p></td></ tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117341"></a>type </pre> </td> <td cla ss="Formal"><a name="117343"></a> <p class="TB">Type of the object that you are replicating. The following types are supported:</p> < pre class="TCI"><a name="117344"></a>FUNCTION SNAPSHOT<a name="117345"></a>INDEX SYNONYM <a name="1173 46"></a>INDEXTYPE TRIGGER <a name="117347"></a>OPERATOR TYPE <a name="117348"></a>PACKAGE T YPE BODY <a name="117349"></a>PACKAGE BODY VIEW <a name="117350"></a>PROCEDURE <a name="119956"></a> </pre> <a name="11995 7"></a> <p class="TB">Use <code>SNAPSHOT</code> type of the object is a materialized view.</p></td></tr> <tr class="Formal" align="le ft" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117358"></a>ddl_text </pre> </td> <td class="Formal"><a name="117360" ></a> <p class="TB">For objects of type <code>MATERIALIZED</code> <code>VIEW</code>, the DDL needed to create the object. For other t ypes, use the default:</p> <pre class="TCI"><a name="117361"></a>'' (an empty string) </pre> <a name="117362"></a> <p class="TB">If a materialized view with the same name already exists, then Oracle ignores the DDL and registers the existing materialized view as a replicated object. If the master table or master materialized view for a materialized view does not exist in the replication group of the master designated for this schema, then Oracle raises a <code>missingobject</code> error. <a name="117363"></a></p> <p class="TB ">If the DDL is supplied without specifying a schema, then the default schema is the replication administrator's schema. Be sure to s pecify the schema if it is other than the replication administrator's schema. <a name="117364"></a></p> <p class="TB">If the object i s not of type <code>MATERIALIZED VIEW</code>, then the materialized view site connects to the master site or master materialized view site and pulls down the DDL text to create the object. If the object type is <code>TYPE</code> or <code>TYPE</code> <code>BODY</code >, then the object identifier (OID) for the object at the materialized view site is the same as the OID at the master site or master materialized view site.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117 366"></a>comment </pre> </td> <td class="Formal"><a name="117368"></a> <p class="TB">This comment is added to the <code>OBJECT_COMMEN T</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="117370"></a>gname </pre> </td> <td class="Formal"><a name="117372"></a> <p class="TB">Name of the replica ted materialized view group to which you are adding an object. The schema name is used as the default group name if none is specified , and a materialized view group with the same name as the schema must exist for the procedure to complete successfully.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117374"></a>gen_objs_owner </pre> </td> <td class="Formal"><a name="117376"></a> <p class="TB">Name of the user you want to assign as owner of the transaction.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117378"></a>min_communication </pre> </t d> <td class="Formal"><a name="117380"></a> <p class="TB">This parameter is obsolete. Use the default value (<code>true</code>).</p>< /td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="117390"></a>generate_80_compati ble </pre> </td> <td class="Formal"><a name="117392"></a> <p class="TB">Set to <code>true</code> if the materialized view's master si te is running a version of Oracle server prior to Oracle release 8.1.5. Set to <code>false</code> if the materialized view's master s ite or master materialized view site is running Oracle release 8.1.5 or greater.</p></td></tr> <tr class="Formal" align="left" valign ="top"> <td class="Formal"> <pre class="CEW"><a name="117394"></a>gowner </pre> </td> <td class="Formal"><a name="117396"></a> <p cla ss="TB">Owner of the materialized view group.</p></td></tr></tbody></table> <a name="109153"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Exceptions</font></h3> <h5 class="TT"><a name="109212"></a><a name="109157"></a> <strong><fon t face="Arial, Helvetica, sans-serif"><em>Table 18-60 CREATE_MVIEW_REPOBJECT Procedure Exceptions </em></font></strong></h5> <t able 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="109161"></a> <font face="Arial, Helvetica, sans-serif"><strong>Exception</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="10 9163"></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="109165"></a>nonmview </pre> </td> <td class="Formal"><a nam e="109167"></a> <p class="TB">Invocation site is not a materialized view site.</p></td></tr> <tr class="Formal" align="left" valign=" top"> <td class="Formal"> <pre class="CEW"><a name="109169"></a>nonmaster </pre> </td> <td class="Formal"><a name="109171"></a> <p cl ass="TB">Master is no longer a master site or master materialized view site.</p></td></tr> <tr class="Formal" align="left" valign="to p"> <td class="Formal"> <pre class="CEW"><a name="109173"></a>missingobject </pre> </td> <td class="Formal"><a name="109175"></a> <p class="TB">Specified object does not exist in the master's replication group.</p></td></tr> <tr class="Formal" align="left" valign="t op"> <td class="Formal"> <pre class="CEW"><a name="109177"></a>duplicateobject </pre> </td> <td class="Formal"><a name="109179"></a> <p class="TB">Specified object already exists with a different shape.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109181"></a>typefailure </pre> </td> <td class="Formal"><a name="109183"></a> <p class="TB ">Type is not an allowable type.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109185"></a>ddlfailure </pre> </td> <td class="Formal"><a name="109187"></a> <p class="TB">DDL did not succeed.</p></td></tr> < tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109189"></a>commfailure </pre> </td> <td c lass="Formal"><a name="109191"></a> <p class="TB">Master site or master materialized view site is not accessible.</p></td></tr> <tr c lass="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109193"></a>missingschema </pre> </td> <td cla ss="Formal"><a name="109195"></a> <p class="TB">Schema does not exist as a database schema.</p></td></tr> <tr class="Formal" align="l eft" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109197"></a>badmviewddl </pre> </td> <td class="Formal"><a name="109 199"></a> <p class="TB">DDL was executed but materialized view does not exist.</p></td></tr> <tr class="Formal" align="left" valign=" top"> <td class="Formal"> <pre class="CEW"><a name="109201"></a>onlyonemview </pre> </td> <td class="Formal"><a name="109203"></a> <p class="TB">Only one materialized view for master table or master materialized view can be created.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109205"></a>badmviewname </pre> </td> <td class="Formal"><a name="109207"></a> <p class="TB">Materialized view differs from master table or master materialized view.</p></td></tr> <tr class="Fo rmal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109209"></a>missingrepgroup </pre> </td> <td class="Fo rmal"><a name="109211"></a> <p class="TB">Replication group at the master does not exist.</p></td></tr></tbody></table></div> <div cl ass="footer"> <hr> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td style="width: 33%;" align="left"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center" valign="top"><a href="rarrca 28.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="rarrca30.htm"><img src="../../dcommon/gifs/rarrow.g if" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td></tr></table></td> <td style="width: 34%;" align="cente r"><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: 33%;" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img sr c="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home</font></a></td> <td align="ce nter" 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="ind ex.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" valign="top"><a href="../../dcommon/html/feedback.htm"><i mg src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback</font></a></td></tr></tab le></td></tr></table></div> </body> </html>