Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\materialized014.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>Managing Materialized View Log Space</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-23T10:13:5Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Managing Materialized View Log Space" /> <meta name="relnum" content="11g Release 1 (11.1)" /> <meta name="partnum" content="A12345-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="materialized013.htm" title="Previous" type="text/html" /> <link rel="next" href="materialized015.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> <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="materialized013.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized015.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BEIFEIJD" name="BEIFEIJD"></a><a id="ADVRP231" name="ADVRP231"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Managing Materialized View Log Space</h1> <p>Oracle automatically tracks which rows in a materialized view log have been used during the refreshes of materialized views, and purges these rows from the log so that the log does not grow endlessly. Because multiple simple materialized views can use the same materialized view log, rows already used to refresh one materialized view may still be needed to refresh another materialized view. Oracle does not delete rows from the log until all materialized views have used them.</p> <p>For example, suppose two materialized views were created against the <code>CUSTOMERS</code> table in a master site. Oracle refreshes the <code>CUSTOMERS</code> materialized view at the <code>SPDB1</code> database. However, the server that manages the master table and associated materialized view log does not purge the materialized view log rows used during the refresh of this materialized view until the <code>CUSTOMERS</code> materialized view at the <code>SPDB2</code> database also refreshes using these rows.</p> <p>Because Oracle must wait for all dependent materialized views to refresh before purging rows from a materialized view log, unwanted situations can occur that cause a materialized view log to grow indefinitely when multiple materialized views are based on the same master table. For example, such situations can occur when more than one materialized view is based on a master table and one of the following conditions is true:</p> <ul> <li> <p>One materialized view is not configured for automatic refreshes and has not been manually refreshed for a long time.</p> </li> <li> <p>One materialized view has an infrequent refresh interval, such as every year (365 days).</p> </li> <li> <p>A network failure has prevented an automatic refresh of one or more of the materialized views based on the master table.</p> </li> <li> <p>A network or site failure has prevented a master from becoming aware that a materialized view has been dropped.</p> </li> </ul> <p>Because of situations such as these, you may need to manually purge rows from your materialized view log using the <code>DBMS_SNAPSHOT.PURGE_LOG</code> procedure, or you may need to <code>TRUNCATE</code> your materialized view log.</p> <p>If you purge or <code>TRUNCATE</code> the materialized view log before a materialized view has refreshed the changes that were deleted, the materialized view must perform a complete refresh.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPMA','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication Management API Reference</span></a> contains detailed information about managing space in your materialized view logs.</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="deployment002.htm#BABIDIHJ">Flowchart for Using Deployment Templates</a></p> <p><a href="deployment003.htm#BABBDEHC">Creating a Deployment Template</a></p> <p><a href="materialized017.htm#BEIHFIDI">Creating a Materialized View Group</a></p> <p><a href="basic_concepts017.htm#CHDGCIGA">Materialized View Logs</a></p> <p><a href="materialized002.htm#BEIHCICE">Creating Materialized View Logs</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 © 2005, 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="materialized013.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized015.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