RENAME_SHADOW_COLUMN_GROUP Procedure</ title> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Language" content="EN"> <me ta http-equiv="Content-Style-Type" content="text/css"> <meta http-equiv="Content-Script-Type" content="text/javascript"> <meta name=" robots" content="all" scheme="http://www.robotstxt.org/"> <meta name="doctitle" content="Oracle® Database Advanced Replication Ma nagement API Reference 10g Release 1 (10.1)"> <meta name="partno" content="B10733-01"> <link rel="Start" href="../../index.htm" title ="Home" type="text/html"> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html"> <link rel="Sty lesheet" href="../../dcommon/css/doccd.css" title="Default" type="text/css"> <link rel="Contents" href="toc.htm" title="Contents" typ e="text/html"> <link rel="Index" href="index.htm" title="Index" type="text/html"> <link rel="Prev" href="rarrca57.htm" title="Previou s" type="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next" href="rarrca59.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"><strong>Oracle® Database Advanced Replication Management API Reference<br> 10<i>g</i> Release 1 (10.1)</strong><br> Part Number B10733-01</font></td> <td valign="bott om" 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 Lis t" border="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcommo n/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="../../dcommon/gifs/mix.gif" alt="Go to Mast er Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../../dcommon/ht ml/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 al ign="left" valign="top"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="cent er" valign="top"><a href="rarrca57.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="G o to current chapter" border="0"><br> <font size="-2">Up</font></a></td> <td align="center" valign="top"><a href="rarrca59.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></table> <a name="BEGIN"></a></div> < div class="IND"> <a name="105288"></a> <h2 class="CM2"><font face="Arial, Helvetica, sans-serif" color="#330099"> RENAME_SHADOW_COLUMN_GROUP Procedure</font></h2> <a name="105289"></a> <p class="BP">This procedure renames the shadow column group of a replicated table to make it a named column group. The replicated table's master group does not need to be quiesced to run this p rocedure.</p> <a name="105290"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Syntax</font></h3> <pr e class="CE"><a name="105291"></a>DBMS_REPCAT.RENAME_SHADOW_COLUMN_GROUP ( <a name="105292"></a> sname IN VARCHAR2, <a name="105293"></a> oname IN VARCHAR2, <a name="105294"></a> new_col_group_name IN VARCHAR2) </pre> <a name=" 105295"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Parameters</font></h3> <h5 class="TT"><a name= "105317"></a><a name="105298"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-118 RENAME_SHADOW_COLUMN_GROUP Proc edure Parameters </em></font></strong></h5> <table summary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="10 0%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" s cope="col"><a name="105302"></a> <font face="Arial, Helvetica, sans-serif"><strong>Parameter</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="105304"></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="105306" ></a>sname </pre> </td> <td class="Formal"><a name="105308"></a> <p class="TB">Schema in which the replicated table is located.</p></ td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="105310"></a>oname </pre> </td> < td class="Formal"><a name="105312"></a> <p class="TB">Name of the replicated table.</p></td></tr> <tr class="Formal" align="left" val ign="top"> <td class="Formal"> <pre class="CEW"><a name="105314"></a>new_col_group_name </pre> </td> <td class="Formal"><a name="1053 16"></a> <p class="TB">Name of the new column group. The columns currently in the shadow group are placed in a column group with the name you specify.</p></td></tr></tbody></table> <a name="105318"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" colo r="#330099">Exceptions</font></h3> <h5 class="TT"><a name="105344"></a><a name="105321"></a> <strong><font face="Arial, Helvetica, sa ns-serif"><em>Table 18-119 RENAME_SHADOW_COLUMN_GROUP Procedure Exceptions </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="105325"></a> <font face="Arial, Helvetica, sans-serif"> <strong>Exception</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="105327"></a> <font face=" Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></thead> <tbody> <tr class="Formal" align="left" valign="t op"> <td class="Formal"> <pre class="CEW"><a name="105329"></a>missmview </pre> </td> <td class="Formal"><a name="105331"></a> <p cla ss="TB">The specified schema does not exist.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre cla ss="CEW"><a name="105333"></a>nonmasterdef </pre> </td> <td class="Formal"><a name="105335"></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 ="105337"></a>missingobject </pre> </td> <td class="Formal"><a name="105339"></a> <p class="TB">The specified object does not exist.< /p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="105341"></a>duplicategroup </pre> </td> <td class="Formal"><a name="105343"></a> <p class="TB">The column group that was specified for creation already exists.< /p></td></tr></tbody></table></div> <div class="footer"> <hr> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <t d 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="rarrca57.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="rarrca59 .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 Reserved.</font></ td> <td style="width: 33%;" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" val ign="top"><a href="../../index.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font s ize="-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="../../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 s ize="-2">Feedback</font></a></td></tr></table></td></tr></table></div> </body> </html>