Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_repcont010.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>About Conflicts and Conflict Resolution</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:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Conflicts and Conflict Resolution" /> <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_repcont009.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_repcont011.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_repcont009.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont011.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABGAACC" name="BABGAACC"></a><a id="TDPII074" name="TDPII074"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>About Conflicts and Conflict Resolution<a id="sthref149" name="sthref149"></a><a id="sthref150" name="sthref150"></a><a id="sthref151" name="sthref151"></a><a id="sthref152" name="sthref152"></a><a id="sthref153" name="sthref153"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p><span class="bold">Conflicts</span> occur when two different databases that are sharing data in a table modify the same row in the table at nearly the same time. When these changes are captured at one of these databases and sent to the other database, an apply process detects the conflict when it attempts to apply a row LCR to the table. By default, apply errors are placed in the error queue, where they can be resolved manually. To avoid apply errors, you must configure conflict resolution so that apply processes handle conflicts in the best way for your environment.</p> <p>Oracle Database supplies prebuilt conflict handlers that provide conflict resolution when a conflict results from an <code>UPDATE</code> on a row. These handlers are called <span class="bold">prebuilt update conflict handlers</span>.</p> <p>When an apply process encounters an update conflict for a row LCR that it has dequeued, it must either apply the row LCR or discard it to keep the data in the two databases consistent. The most common way to resolve update conflicts is to keep the change with the most recent time stamp and discard the older change. See <a href="tdpii_repcont025.htm#CIHIACBB">"Tutorial: Configuring Latest Time Conflict Resolution for a Table"</a> for instructions about configuring latest time conflict resolution for a table.</p> <p>The following topics discuss how to configure conflict resolution in a particular type of replication environment:</p> <ul> <li> <p><a href="tdpii_repcont021.htm#CIHDBCGD">Tutorial: Configuring Two-Database Replication with Local Capture Processes</a></p> </li> <li> <p><a href="tdpii_repcont023.htm#BABBIBCD">Tutorial: Configuring Hub-and-Spoke Replication with Local Capture Processes</a></p> </li> <li> <p><a href="tdpii_repcont024.htm#BABDEBBA">Tutorial: Configuring Two-Database Replication with Synchronous Captures</a></p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span>Conflicts are not possible in a replication environment when changes to only one database are captured. In these replication environments, typically the replicas at the other databases are read-only.</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_repcont025.htm#CIHIACBB">Tutorial: Configuring Latest Time Conflict Resolution for a Table</a></p> <p><a href="tdpii_adcont025.htm#CHDCBHGC">Displaying the Configured Update Conflict Handlers</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=STREP001','newWindow').focus()"><span class="italic">Oracle Streams Replication Administrator's Guide</span></a> for detailed information about conflicts and conflict resolution</p> <p><a href="tdpii_repcont001.htm#BABEHDDF">About Oracle Streams Replication</a></p> </div> </div> <!-- class="sect2" --> <!-- 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_repcont009.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_repcont011.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