Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adcont036.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Correcting Apply Errors in Database Objects</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-06-04T17:1:2Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Correcting Apply Errors in Database Objects" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10703-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdpii_adcont035.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adcont037.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdpii_adcont035.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont037.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDEBFIJ" name="CHDEBFIJ"></a><a id="TDPII175" name="TDPII175"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Correcting Apply Errors in Database Objects<a id="sthref357" name="sthref357"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>You might need to make data manipulation language (DML) or data definition language (DDL) changes to database objects to correct the conditions that caused one or more apply errors before you retry error transactions. If you must make changes to a database object, but you do not want to replicate these changes, then set a session tag in the session that makes the changes.</p> <p class="orderedlisttitle">For example, to update the hr.employees table to correct an apply error: </p> <ol> <li> <p>Open SQL*Plus and connect as a user who can update the <code>hr.employees</code> table.</p> <p>See <a href="topicid:ADMQS0361">Starting SQL*Plus and Connecting to the Database</a> for more information about starting SQL*Plus.</p> </li> <li> <p><a id="sthref359" name="sthref359"></a><a id="sthref360" name="sthref360"></a>Set a session tag:</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN DBMS_STREAMS.SET_TAG( tag => HEXTORAW('1D')); END; / </pre> <p>Ensure that you set the tag to a value that prevents changes from being captured by capture processes and synchronous captures.</p> </li> <li> <p>Update the <code>hr.employees</code> table to correct the error.</p> </li> <li> <p>Exit the SQL*Plus session.</p> </li> </ol> <p>After you correct the problem that caused one or more error transactions, you can retry the error transactions or delete them. See <a href="tdpii_adcont037.htm#CHDBEFAF">"Retrying or Deleting Apply Error Transactions"</a> for instructions.</p> <p>For information about specific apply errors and how to correct them, see <a href="topicid:STRMS209">Are There Any Apply Errors in the Error Queue?</a>.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_repcont006.htm#BABBAJFE">About Change Apply</a></p> <p><a href="tdpii_adcont006.htm#CHDIJJGJ">Managing Apply Processes</a></p> <p><a href="tdpii_repcont011.htm#BABICHGF">About Tags for Avoiding Change Cycling</a></p> <p><a href="tdpii_adcont021.htm#CHDBJIHG">Monitoring Apply Processes</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STRMS112','newWindow').focus()"><span class="italic">Oracle Streams Concepts and Administration</span></a></p> </div> </div> <!-- class="sect3" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2007, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdpii_adcont035.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adcont037.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de