Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\materialized013.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>Editing a Materialized View Log</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="Editing a Materialized View Log" /> <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="materialized012.htm" title="Previous" type="text/html" /> <link rel="next" href="materialized014.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="materialized012.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized014.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BEIHEIFI" name="BEIHEIFI"></a><a id="ADVRP230" name="ADVRP230"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Editing a Materialized View Log</h1> <p>To edit the storage settings or filter columns (<a href="newglossary003.htm#BGBBCFIE">Filter Columns</a>) of a materialized view log:</p> <ol> <li> <p>In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.</p> </li> <li> <p>Click <span class="bold">Data Movement</span>.</p> </li> <li> <p>Under the Advanced Replication section, click <span class="bold">Manage</span>. The Advanced Replication: Administration page appears.</p> </li> <li> <p>Under Materialized View Replication, Master Site section, click the number next to <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('MATERIALIZED_VIEW_LOGS');">Materialized View Logs</a> to open the Materialized View Logs page.</p> </li> <li> <p>On the Materialized View Logs page, select the materialized view log that you want to edit.</p> </li> </ol> <p>The Materialized View Log property sheet has three pages: General, Storage, and Options.</p> <ul> <li> <p>Use the settings of the General subpage to specify whether the log supports primary key materialized views, ROWID materialized views, or both. You also use the settings of the General subpage to modify the filter columns (<a href="newglossary003.htm#BGBBCFIE">Filter Columns</a>) for materialized views that contain subqueries.</p> </li> <li> <p>Use the settings of the Storage subpage to modify the storage specifications for the log.</p> </li> <li> <p>Use the settings of the Options subpage to modify parallel setting and logging options.</p> </li> </ul> <p>Click <span class="bold">Help</span> on any of the tabs for information about the controls.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="materialized012.htm#BEIHJHJG">Managing Materialized View Logs</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="materialized012.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized014.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