Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adpit018.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 Problems with Materialized View Refresh</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 Problems with Materialized View Refresh" /> <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_adpit017.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adpit019.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_adpit017.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit019.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABGAEFH" name="BABGAEFH"></a><a id="TDPII132" name="TDPII132"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Correcting Problems with Materialized View Refresh<a id="sthref541" name="sthref541"></a><a id="sthref542" name="sthref542"></a><a id="sthref543" name="sthref543"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>If one or more materialized views at a materialized view site cannot refresh, then the following are typical causes and solutions:</p> <ul> <li> <p>A network problem is preventing one or more materialized views from refreshing. If you have multiple refresh groups and multiple materialized views at a materialized view site, and none of them can refresh, then a network problem is the most likely cause. In this case, correct the network problem, and refresh the relevant materialized views. See <a href="topicid:ADMQS004">Configuring the Network Environment</a> for information about configuring network connectivity between databases.</p> </li> <li> <p>A master site for the materialized views is down. A materialized view cannot refresh if its master site is not open. If you have a materialized view site with materialized views that use multiple master sites, and only the materialized views for a particular master site cannot refresh, then a master site problem is the most likely cause. In this case, check the database at the master site. If it is down, then start it, and refresh the relevant materialized views. See <a href="topicid:ADMQS05144">About Instance Startup</a> for information about starting a database.</p> </li> <li> <p>A database link is broken. If all of the materialized views in a materialized view group cannot refresh, then the database link used to refresh the materialized views might be broken. If a database link is broken, then you can correct the problem by deleting the database link and re-creating it.</p> </li> </ul> <p class="orderedlisttitle">To re-create a broken database link: </p> <ol> <li> <p>Log in to Enterprise Manager as an administrative user, such as <code>SYSTEM</code>.</p> </li> <li> <p>Go to the Database Home page.</p> </li> <li> <p>Click <span class="bold">Schema</span> to open the Schema subpage.</p> </li> <li> <p>Click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('DATABASE_LINKS');"><span class="bold">Database Links</span></a> in the Database Objects section.</p> <p>The Database Links page appears.</p> </li> <li> <p>Use the search tool to list the database link used by the materialized views.</p> <p>The database link name should be the same as the global name of the master site for the materialized views.</p> </li> <li> <p>Select the database link.</p> </li> <li> <p>Click <span class="bold">View</span>.</p> </li> <li> <p>On the View Database Link page, click <span class="bold">Test</span> to see if the database link is active. If it is active, then the materialized view refresh problems are caused by a different issue. If the database link is not active, then follow Steps <a href="#BABDEHBA">9</a> through <a href="#BABBFAAB">13</a> to delete it and re-create it.</p> </li> <li><a id="BABDEHBA" name="BABDEHBA"></a> <p>Click <span class="bold">OK</span> to return to the Database Links page.</p> </li> <li> <p>Select the database link.</p> </li> <li> <p>Click <span class="bold">Delete</span>.</p> </li> <li> <p>Click <span class="bold">Yes</span> on the confirmation page to delete the database link.</p> </li> <li><a id="BABBFAAB" name="BABBFAAB"></a> <p>Follow the instructions in <a href="tdpii_common_ii006.htm#BGBGIACD">"Tutorial: Creating a Database Link"</a> to re-create the database link.</p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_reppit003.htm#BEHBEBJA">About Materialized View Refresh</a></p> <p><a href="tdpii_adpit002.htm#BABEDJGH">Refreshing Materialized Views</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPLN008','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication</span></a></p> <p><a href="tdpii_adpit017.htm#CIHHICBI">Troubleshooting 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_adpit017.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit019.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