GENERATE_MVIEW_SUPPORT 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="rarrca46.htm" title="Previous" t ype="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next" href="rarrca48.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="rarrca46.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="rarrca48.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="112665"></a> <h2 class="CM2"><font face="Arial, Helvetica, sans-serif" color="#330099">GENE RATE_MVIEW_SUPPORT Procedure</font></h2> <a name="109473"></a> <p class="BP">This procedure activates triggers and generate packages needed to support the replication of updatable materialized views or procedural replication.You must call this procedure from the ma terialized view site.</p> <a name="109478"></a> <div align="center"> <table class="Note" border="0" width="80%" cellpadding="0" cell spacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="N ote"> <td class="Note"> <hr> <a name="109476"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">Note:</strong></font> <a name="109477"></a> <p class="NB"><code>CREATE_MVIEW_REPOBJECT</code> automatically generates materialized view support for updata ble materialized views.</p> <hr></td></tr></table></div> <a name="109479"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-se rif" color="#330099">Syntax</font></h3> <pre class="CE"><a name="109481"></a>DBMS_REPCAT.GENERATE_MVIEW_SUPPORT ( <a name="109482"></ a> sname IN VARCHAR2, <a name="109483"></a> oname IN VARCHAR2, <a name="109484"></a> type IN VARCHAR2, <a name="109485"></a> gen_objs_owner IN VARCHAR2 := '', <a name="109486"></a> min_com munication IN BOOLEAN := true, <a name="109487"></a> generate_80_compatible IN BOOLEAN := true); </pre> <a name="109488 "></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Parameters</font></h3> <h5 class="TT"><a name="10952 3"></a><a name="109492"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-96 GENERATE_MVIEW_SUPPORT Procedure Param eters </em></font></strong></h5> <table summary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpad ding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" scope="col"> <a name="109496"></a> <font face="Arial, Helvetica, sans-serif"><strong>Parameter</strong></font></th> <th class="Formal" align="left " valign="bottom" scope="col"><a name="109498"></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="109500"></a>sname </pre> </td> <td class="Formal"><a name="109502"></a> <p class="TB">Schema in which the object is located.</p></td></tr> <tr class="F ormal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109504"></a>oname </pre> </td> <td class="Formal"><a name="109506"></a> <p class="TB">The name of the object for which you are generating support.</p></td></tr> <tr class="Formal" align= "left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109508"></a>type </pre> </td> <td class="Formal"><a name="109510"> </a> <p class="TB">Type of the object. The types supported are <code>MATERIALIZED VIEW</code>, <code>PACKAGE</code>, and <code>PACKAG E BODY</code>.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109512"></a> gen_objs_owner </pre> </td> <td class="Formal"><a name="109514"></a> <p class="TB">For objects of type <code>PACKAGE</code> or <code> PACKAGE BODY</code>, the schema in which the generated object should be created. If <code>NULL</code>, the objects are created in <co de>SNAME</code>.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109516"></ a>min_communication </pre> </td> <td class="Formal"><a name="109518"></a> <p class="TB">If <code>true</code>, then the update trigger sends the new value of a column only if the update statement modifies the column. The update trigger sends the old value of the colu mn only if it is a key column or a column in a modified column group.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109520"></a>generate_80_compatible </pre> </td> <td class="Formal"><a name="109522"></a> < p class="TB">Set to <code>true</code> if the materialized view's master site is running a version of Oracle server prior to Oracle re lease 8.1.5. Set to <code>false</code> if the materialized view's master site or master materialized view site is running Oracle rele ase 8.1.5 or higher.</p></td></tr></tbody></table> <a name="109524"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" c olor="#330099">Exceptions</font></h3> <h5 class="TT"><a name="109559"></a><a name="109528"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-97 GENERATE_MVIEW_SUPPORT Procedure Exceptions </em></font></strong></h5> <table summary="" class="Fo rmal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Fo rmal"> <th class="Formal" align="left" valign="bottom" scope="col"><a name="109532"></a> <font face="Arial, Helvetica, sans-serif"><s trong>Exceptions</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="109534"></a> <font face="A rial, Helvetica, sans-serif"><strong>Descriptions</strong></font></th></tr></thead> <tbody> <tr class="Formal" align="left" valign="t op"> <td class="Formal"> <pre class="CEW"><a name="109536"></a>nonmview </pre> </td> <td class="Formal"><a name="109538"></a> <p clas s="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="109540"></a>missingobject </pre> </td> <td class="Formal"><a name="109542"></a> <p class="TB">Specified object does not exist as a materialized view in the replicated schema waiting for row/column-level replication information or as a pa ckage (body) waiting for wrapper generation.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre cla ss="CEW"><a name="109544"></a>typefailure </pre> </td> <td class="Formal"><a name="109546"></a> <p class="TB">Specified type paramete r is not supported.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109548" ></a>missingschema </pre> </td> <td class="Formal"><a name="109550"></a> <p class="TB">Specified owner of generated objects does not exist.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="109552"></a>missingr emoteobject </pre> </td> <td class="Formal"><a name="109554"></a> <p class="TB">Object at master site or master materialized view sit e has not yet generated replication support.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre cla ss="CEW"><a name="109556"></a>commfailure </pre> </td> <td class="Formal"><a name="109558"></a> <p class="TB">Master site or master m aterialized view site is not accessible.</p></td></tr></tbody></table></div> <div class="footer"> <hr> <table summary="" cellspacing= "0" cellpadding="0" width="100%"> <tr> <td style="width: 33%;" align="left"> <table summary="layout table" cellspacing="0" cellpaddin g="0" align="left" width="135"> <tr> <td align="center" valign="top"><a href="rarrca46.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 alig n="center" valign="top"><a href="rarrca48.htm"><img src="../../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0"><br> <font s ize="-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> <fon t 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 src="../../dcommon/gifs/prodicon.gif" alt="Go to Do cumentation Home" border="0"><br> <font size="-2">Home</font></a></td> <td align="center" valign="top"><a href="../../nav/portal_3.ht m"><img src="../../dcommon/gifs/bookicon.gif" alt="Go to Book List" border="0"><br> <font size="-2">Book List</font></a></td> <td ali gn="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/b120 39/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"><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>