Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\materialized002.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>Creating Materialized View Logs</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="Creating Materialized View Logs" /> <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="materialized001.htm" title="Previous" type="text/html" /> <link rel="next" href="materialized003.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="materialized001.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized003.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BEIHCICE" name="BEIHCICE"></a><a id="ADVRP210" name="ADVRP210"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Creating Materialized View Logs</h1> <p>Before creating materialized view groups and materialized views for a remote materialized view site, create the necessary materialized view logs at the master site. A materialized view log is necessary for every master table that supports at least one materialized view with fast refreshes. You should create these materialized view logs regardless of whether the materialized view site is created manually or by using a deployment template.</p> <p>To create a materialized view log at the master site:</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 Materialized View Logs to open the Materialized View Logs page.</p> </li> <li> <p>On the Materialized View Logs page, click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('MATERIALIZED_VIEW_LOG_CREATE');"><span class="bold">Create</span></a>.</p> <p>The Create Materialized View Log page appears.</p> </li> <li> <p>Specify the appropriate table from a schema in the Schema.Table field.</p> <p>To search for the table in the specified schema that contains the table for which you want to create a materialized view log, click the <span class="bold">Search</span> icon next to the field.</p> <ul> <li> <p>Specify the schema in the Schema field that contains the table for which you want to create a materialized view log.</p> </li> <li> <p>Select the table for which you want to create a materialized view log from the Table list.</p> </li> </ul> </li> <li> <p>Click <span class="bold">Populate Columns</span> to display the columns available in the selected table in the Available Columns list in the Filter Columns section.</p> </li> <li> <p>Select the tablespace where you want to store the materialized view log from the Tablespace list.</p> <p>Click the <span class="bold">Search</span> icon next to the field to search for the appropriate tablespace.</p> </li> <li> <p>Select the appropriate <span class="bold">Refresh Types</span>:</p> <p><span class="bold">Row ID</span>: Enable this box to allow the selected materialized view to use <code>ROWIDs</code> when refreshing. <code>ROWID</code> materialized views may be used for materialized views based on master tables that do not have a primary key, or for materialized views that do not include all primary key columns of the master tables.</p> <p><span class="bold">Primary Key</span>: Enable this box to allow the selected materialized view to use primary key when refreshing. This option is the default.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>If the master table does not have a primary key, then the <span class="bold">Primary Key</span> box is disabled and the <span class="bold">Row ID</span> box is selected by default. If your materialized view log must support both Row ID and Primary Key materialized views, be sure that you enable both the <span class="bold">Row ID</span> and the <span class="bold">Primary Key</span> boxes.</p> </div> </li> <li> <p>If necessary, enable the <span class="bold">Include New Values</span> box.</p> <p>When enabled, this box specifies that the materialized view log records both old and new values when a table update is made. Typically, you would only enable this option in a data warehousing environment with fast-refreshable single-table aggregates. Disable this option for a typical replication environment.</p> </li> <li> <p>If necessary, enable the <span class="bold">With Sequence Value</span> box.</p> <p>When enabled, this box specifies that a sequence value providing additional ordering information should be recorded in the materialized view log. If you plan to have aggregate materialized views, then sequence numbers are necessary to support fast refresh after some update scenarios. Typically, this option should only be enabled if you plan to have aggregate materialized views based on the master table in a data warehousing environment. Disable this option for a typical replication environment.</p> </li> <li> <p>If necessary, select any required filter columns (<a href="newglossary003.htm#BGBBCFIE">Filter Columns</a>) from the Available Columns list to identify filter columns for materialized views that contain subqueries.</p> </li> <li> <p>Click the right-arrow button to add the selected columns to the Filter Columns list.</p> </li> <li> <p>If necessary, click <span class="bold">Storage</span> and Options subpage to modify the storage settings and options for your materialized view log.</p> <p>Click <span class="bold">Help</span> on either of these tabs to see additional information about the available storage settings and options.</p> </li> <li> <p>Click <span class="bold">OK</span> to complete the creation of your materialized view log.</p> </li> </ol> <div class="helpinfonote"> <p><span class="bold">Note: </span>You can set an Oracle Enterprise Manager event to alert you if the number rows in a materialized view log exceeds a specified limit. See the Oracle Enterprise Manager documentation and online help for information about setting Oracle Enterprise Manager events.</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="materialized003.htm#BEIBHBJA">Creating a Materialized View Group</a></p> <p><a href="basic_concepts017.htm#CHDGCIGA">Materialized View Logs</a></p> </div> </div> <!-- class="sect1" --> <!-- 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="materialized001.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized003.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