Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\materialized027.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>Removing Materialized Views from a Refresh Group</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="Removing Materialized Views from a Refresh Group" /> <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="materialized026.htm" title="Previous" type="text/html" /> <link rel="next" href="materialized028.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="materialized026.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized028.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHHIJJC" name="CIHHIJJC"></a><a id="ADVRP245" name="ADVRP245"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Removing Materialized Views from a Refresh Group</h1> <p>To remove materialized views from a refresh group:</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 Site section, click the number next to <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('REFRESH_GROUPS');">Refresh Groups</a> to open the Refresh Groups page.</p> </li> <li> <p>Select the target refresh group to which you want to add materialized view to and click <span class="bold">Edit</span>.</p> <p>The General subpage of the Edit Refresh Group page appears.</p> </li> <li> <p>Click <span class="bold">Materialized Views</span>.</p> </li> <li> <p>Select the materialized view that you want to remove from the refresh group.</p> </li> <li> <p>Click <span class="bold">Remove</span>.</p> </li> <li> <p>Click <span class="bold">Apply</span>.</p> </li> </ol> <div class="helpinfonote"> <p><span class="bold">Note: </span>After you drop a materialized view from refresh group, Oracle no longer refreshes the materialized view automatically as part of the refresh group. To refresh the materialized view, you must add it to another refresh group or refresh it manually.</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="materialized022.htm#CIHCIBDD">Managing Refresh Groups</a></p> <p><a href="basic_concepts016.htm#CHDGAIDB">Refresh Groups</a></p> <p><a href="basic_concepts010.htm#CHDIEEDI">What Is Materialized View Replication?</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="materialized026.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="materialized028.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