Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_adpit012.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 Materialized View Groups</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 Materialized View Groups" /> <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_adpit011.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_adpit013.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_adpit011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit013.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABHDIJF" name="BABHDIJF"></a><a id="TDPII116" name="TDPII116"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Viewing Information About Materialized View Groups<a id="sthref519" name="sthref519"></a><a id="sthref520" name="sthref520"></a><a id="sthref521" name="sthref521"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>Materialized view groups make it easy to manage materialized views that are logically related. For example, you might add all of the materialized views in a schema or all of the materialized views used by an application to a materialized view group. Also, for materialized views to be updatable, they must belong to a materialized view group.</p> <p class="orderedlisttitle">To view information about the materialized view groups at a materialized view site: </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('MV_GROUPS');">Materialized View Groups</a> in the Materialized View Site section.</p> <p>The Materialized View Groups page appears, listing the names of the materialized view groups at the materialized view site.</p> </li> <li> <p>To view detailed information about a materialized view group, click the name of the materialized view group to open the View Materialized View Group page.</p> </li> </ol> <p>The View Materialized View Group page includes the following information:</p> <ul> <li> <p>In the Link To Master field, the name of the database link to the master site. The master site contains the master tables of the materialized views in the materialized view group.</p> </li> <li> <p>In the Propagation Mode field, Asynchronous is displayed because the propagation sends messages according to a propagation schedule.</p> </li> <li> <p>In the Description field, a description of the materialized view group if the group has a description.</p> </li> <li> <p>In the Objects section, a list of the database objects in the materialized view group and information about each database object</p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span>You can also query the following data dictionary views for information about materialized view groups: <ul> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPMA126','newWindow').focus()"><code>ALL_REPGROUP</code></a></p> </li> <li> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPMA127','newWindow').focus()"><code>ALL_REPSITES</code></a></p> </li> </ul> </p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_reppit013.htm#BEHIGFCF">About Replication Groups and Updatable Materialized Views</a></p> <p><a href="tdpii_reppit002.htm#BEHFGHIE">About Master Sites, Master Tables, and Materialized View Sites</a></p> <p><a href="tdpii_reppit011.htm#BEHCEFGC">Replicating Read/Write Data Using Materialized Views</a></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_adpit011.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_adpit013.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