REGISTER_MVIEW_REPGROUP 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"> <link rel="Start" href="../../index.htm" title="H ome" type="text/html"> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html"> <link rel="Styles heet" href="../../dcommon/css/doccd.css" title="Default" type="text/css"> <link rel="Contents" href="toc.htm" title="Contents" type=" text/html"> <link rel="Index" href="index.htm" title="Index" type="text/html"> <link rel="Prev" href="rarrca53.htm" title="Previous" type="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next" href="rarrca55.htm" title="Next" t ype="text/html"> <link rel="alternate" href="../b10733.pdf" title="PDF version" type="application/pdf"> </head> <body> <div class="he ader"> <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"><strong>Oracle® Database Advanced Rep lication 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="../../in dex.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home</font></a></t d> <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/g ifs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valign="t op"><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" 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> <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="rarrca53.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 t o current chapter" border="0"><br> <font size="-2">Up</font></a></td> <td align="center" valign="top"><a href="rarrca55.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 ali gn="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="117691"></a> <h2 class="CM2"><font face="Arial, Helvetica, sans-serif" color="#330099">REG ISTER_MVIEW_REPGROUP Procedure</font></h2> <a name="117692"></a> <p class="BP">This procedure facilitates the administration of mate rialized views at their respective master sites or master materialized view sites by inserting or modifying a materialized view group in <code>DBA_REGISTERED_MVIEW_GROUPS</code>.</p> <a name="98468"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" col or="#330099">Syntax</font></h3> <pre class="CE"><a name="98469"></a>DBMS_REPCAT.REGISTER_MVIEW_REPGROUP ( <a name="98470"></a> gnam e IN VARCHAR2, <a name="98471"></a> mviewsite IN VARCHAR2, <a name="98472"></a> comment IN VARCH AR2 := NULL, <a name="98473"></a> rep_type IN NUMBER := reg_unknown, <a name="98474"></a> fname IN VAR CHAR2 := NULL, <a name="98475"></a> gowner IN VARCHAR2 := 'PUBLIC'); </pre> <a name="98476"></a> <h3 class="CMS"><fo nt face="Arial, Helvetica, sans-serif" color="#330099">Parameters</font></h3> <h5 class="TT"><a name="98516"></a><a name="98480"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-110 REGISTER_MVIEW_REPGROUP Procedure Parameters </em></font></ strong></h5> <table summary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" d ir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" scope="col"><a name="98484"></a> <font face="Arial, Helvetica, sans-serif"><strong>Parameter</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="co l"><a name="98486"></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></thead> <tbody> <tr c lass="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="98488"></a>gname </pre> </td> <td class="Forma l"><a name="98490"></a> <p class="TB">Name of the materialized view group to be registered.</p></td></tr> <tr class="Formal" align="l eft" valign="top"> <td class="Formal"> <pre class="CEW"><a name="98492"></a>mviewsite </pre> </td> <td class="Formal"><a name="98494" ></a> <p class="TB">Global name of the materialized view site.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class= "Formal"> <pre class="CEW"><a name="98496"></a>comment </pre> </td> <td class="Formal"><a name="98498"></a> <p class="TB">Comment for the materialized view site or update for an existing comment.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class= "Formal"> <pre class="CEW"><a name="98500"></a>rep_type </pre> </td> <td class="Formal"><a name="98502"></a> <p class="TB">Version of the materialized view group. Valid constants that can be assigned include the following:</p> <ul class="TLB"> <li class="TLB" type=" disc"><a name="98503"></a><code>dbms_repcat.reg_unknown</code> (the default)</li> <li class="TLB" type="disc"><a name="98504"></a><co de>dbms_repcat.reg_v7_group</code></li> <li class="TLB" type="disc"><a name="98506"></a><code>dbms_repcat.reg_v8_group</code></li></u l></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="98508"></a>fname </pre> </td > <td class="Formal"><a name="98510"></a> <p class="TB">This parameter is for internal use only. <a name="98511"></a></p> <p class="T B"><strong class="Bold">Note:</strong> Do not set this parameter unless directed to do so by Oracle Support Services.</p></td></tr> < tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="98513"></a>gowner </pre> </td> <td class=" Formal"><a name="98515"></a> <p class="TB">Owner of the materialized view group.</p></td></tr></tbody></table> <a name="98517"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Exceptions</font></h3> <h5 class="TT"><a name="98547"></a>< a name="98520"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-111 REGISTER_MVIEW_REPGROUP Procedure Exceptions & 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 ="98524"></a> <font face="Arial, Helvetica, sans-serif"><strong>Exception</strong></font></th> <th class="Formal" align="left" valign ="bottom" scope="col"><a name="98526"></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></t head> <tbody> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="98528"></a>failregmviewrepg roup </pre> </td> <td class="Formal"><a name="98530"></a> <p class="TB">Registration of materialized view group failed.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="98532"></a>missingrepgroup </pre> </td> <td class="Formal"><a name="98534"></a> <p class="TB">Replication group name not specified.</p></td></tr> <tr class="Formal" align="l eft" valign="top"> <td class="Formal"> <pre class="CEW"><a name="98536"></a>nullsitename </pre> </td> <td class="Formal"><a name="985 38"></a> <p class="TB">A materialized view site was not specified.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td cl ass="Formal"> <pre class="CEW"><a name="98540"></a>nonmaster </pre> </td> <td class="Formal"><a name="98542"></a> <p class="TB">Proce dure must be executed at the materialized view's 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="98544"></a>duplicaterepgroup </pre> </td> <td class="Formal"><a n ame="98546"></a> <p class="TB">Replication group already exists.</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" ce llspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center" valign="top"><a href="rarrca53.htm"><img src="../../d common/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="rarrca55.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="../../dcommo n/gifs/oracle.gif" alt="Oracle"><br> <a href="../../dcommon/html/cpyr.htm"><font size="-2">Copyright © 1996, 2003 Oracle Corpora tion</font></a><br> <font size="-2">All Rights Reserved.</font></td> <td style="width: 33%;" align="right"> <table summary="" cellspa cing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img src="../../dcommon/gifs/pro dicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home</font></a></td> <td align="center" valign="top"><a hre f="../../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 Con tents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valign="top"><a href="index.htm"><img src="../../d common/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">Ma ster Index</font></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img src="../../dcommon/gif s/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback</font></a></td></tr></table></td></tr></table></di v> </body> </html>