RESUME_PROPAGATION_TO_MDEF 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="rarrca60.htm" title="Previou s" type="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next" href="rarrca62.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="rarrca60.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="rarrca62.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="112759"></a> <h2 class="CM2"><font face="Arial, Helvetica, sans-serif" color="#330099"> RESUME_PROPAGATION_TO_MDEF Procedure</font></h2> <a name="112760"></a> <p class="BP">During the process of adding new master sites t o a master group without quiesce, this procedure indicates that export is effectively finished and propagation to the master definiti on site for both extended and unaffected replication groups existing at master sites can be enabled. Run this procedure after the exp ort required to add new master sites to a master group is complete.</p> <a name="112771"></a> <div align="center"> <table class="Not eAlso" border="0" width="80%" cellpadding="0" cellspacing="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="NoteAlso"> <td class="NoteAlso"><a name="112763"></a><font face="Arial, Helvetica, s ans-serif"><strong class="NH">See Also:</strong></font> <a name="112770"></a> <p class="NB"><a href="rarmanma.htm#33125">"Adding New Master Sites"</a><a href="rarmanma.htm#33125"></a> for more information about adding master sites to a master group</p></td></tr></t able></div> <a name="112772"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Syntax</font></h3> <pre class="CE"><a name="112774"></a>DBMS_REPCAT.RESUME_PROPAGATION_TO_MDEF ( <a name="112775"></a> extension_id IN R AW); </pre> <a name="112776"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Parameters</font></h3> < h5 class="TT"><a name="112790"></a><a name="112779"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-124 RESUME_PR OPAGATION_TO_MDEF Procedure Parameters </em></font></strong></h5> <table summary="" class="Formal" border="1" frame="HSIDES" ru les="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align="l eft" valign="bottom" scope="col"><a name="112783"></a> <font face="Arial, Helvetica, sans-serif"><strong>Parameter</strong></font></t h> <th class="Formal" align="left" valign="bottom" scope="col"><a name="112785"></a> <font face="Arial, Helvetica, sans-serif"><stron g>Description</strong></font></th></tr></thead> <tbody> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class= "CEW"><a name="112787"></a>extension_id </pre> </td> <td class="Formal"><a name="112789"></a> <p class="TB">The identifier for the cu rrent pending request to add master databases to a master group without quiesce. You can find the <code>extension_id</code> by queryi ng the <code>DBA_REPSITES_NEW</code> and <code>DBA_REPEXTENSIONS</code> data dictionary views.</p></td></tr></tbody></table> <a name= "112791"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Exceptions</font></h3> <h5 class="TT"><a nam e="112813"></a><a name="112794"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 18-125 RESUME_PROPAGATION_TO_MDEF Pr ocedure 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="112798"></a> <font face="Arial, Helvetica, sans-serif"><strong>Exception</strong></font></th> <th class="Formal " align="left" valign="bottom" scope="col"><a name="112800"></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</stron g></font></th></tr></thead> <tbody> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="11280 2"></a>nonmasterdef </pre> </td> <td class="Formal"><a name="112804"></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="112806"></a>extstinap p </pre> </td> <td class="Formal"><a name="112808"></a> <p class="TB">Extension status is inappropriate. The extension status should be <code>EXPORTING</code> when you run this procedure. To check the extension status, query the <code>DBA_REPEXTENSIONS</code> data d ictionary view.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="112810"></a >dbnotcompatible </pre> </td> <td class="Formal"><a name="112812"></a> <p class="TB">Feature is incompatible with database version. A ll databases must be at 9.0.1 or higher compatibility level.</p></td></tr></tbody></table></div> <div class="footer"> <hr> <table sum mary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td style="width: 33%;" align="left"> <table summary="layout table" cellsp acing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center" valign="top"><a href="rarrca60.htm"><img src="../../dcomm on/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</fon t></a></td> <td align="center" valign="top"><a href="rarrca62.htm"><img src="../../dcommon/gifs/rarrow.gif" alt="Go to next page" bor der="0"><br> <font size="-2">Next</font></a></td></tr></table></td> <td style="width: 34%;" align="center"><img src="../../dcommon/gi fs/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 src="../../dcommon/gifs/prodico n.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</fo nt></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcommon/gifs/conticon.gif" alt="Go to Table of Content s" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valign="top"><a href="index.htm"><img src="../../dcomm on/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/fe edback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback</font></a></td></tr></table></td></tr></table></div>