Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adpit013.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>Viewing Information About Deferred Transactions for Updatable Materialized Views</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="Viewing Information About Deferred Transactions for Updatable Materialized Views" /> <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_adpit012.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adpit014.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_adpit012.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit014.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABGFIFJ" name="BABGFIFJ"></a><a id="TDPII131" name="TDPII131"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Viewing Information About Deferred Transactions for Updatable Materialized Views<a id="sthref523" name="sthref523"></a><a id="sthref524" name="sthref524"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>At a materialized view site, deferred transactions include changes to updatable materialized views. The deferred transactions are stored at the materialized view site so that they can be sent to the master site and applied to master tables. Deferred transactions for a materialized view are always pushed when a materialized view is refreshed. A scheduled link determines when the deferred transactions are pushed to the master site independent of the refresh process.</p> <p class="orderedlisttitle">To view information about deferred transactions for updatable materialized views: </p> <ol> <li> <p>In Enterprise Manager, log in to the materialized view site as the materialized view administrator. The default user name for the materialized view administrator is <code>mvadmin</code>.</p> </li> <li> <p>Go to the Database Home page.</p> </li> <li> <p>Click <span class="bold">Data Movement</span> to open the Data Movement subpage.</p> </li> <li> <p>Click <span class="bold">Manage</span> in the Advanced Replication section.</p> <p>The Advanced Replication: Administration page appears, showing the Overview subpage.</p> </li> <li> <p>Click the number associated with <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('DEFERRED_TRANSACTIONS');">Deferred Transactions</a> in the General section to open the Administration: Deferred Transactions page.</p> <p>The Administration: Deferred Transactions page contains the transaction ID and the following information for each deferred transaction:</p> <ul> <li> <p>The Destination field shows the master site to which the deferred transaction will be pushed.</p> </li> <li> <p>The Start Time field shows when the deferred transaction was placed in the deferred transaction queue at the materialized view site.</p> </li> <li> <p>The Number of Calls field typically shows the number of individual rows changed in the transaction.</p> </li> </ul> </li> <li> <p>Click a transaction ID in the Transaction ID column to open the Deferred Transaction page and view more information about the transaction.</p> <p>The Deferred Transaction page shows the materialized view and the type of operation that changed it. For example, <code>REP_UPDATE</code> designates an update operation.</p> </li> <li> <p>To view detailed information about a specific change in the deferred transaction, select the change and click <span class="bold">Details</span>.</p> <p>This page shows each column in the materialized view, along with its original value and, where appropriate, its new value. When there is a new value for a column, then the change modified the column value from the original value to the new value.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_reppit014.htm#CHDEJIJC">About Scheduled Links and Deferred Transactions</a></p> <p><a href="tdpii_reppit013.htm#BEHIGFCF">About Replication Groups and Updatable Materialized Views</a></p> <p><a href="tdpii_reppit011.htm#BEHCEFGC">Replicating Read/Write Data Using Materialized Views</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPMA026','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication Management API Reference</span></a> for information about the data dictionary views related to deferred transactions</p> <p><a href="tdpii_adpit008.htm#CIHJBJJC">Monitoring a Materialized View Replication Environment</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_adpit012.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit014.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