Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\newglossary003.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>Filter Columns</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-23T10:13:6Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Filter Columns" /> <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="newglossary002.htm" title="Previous" type="text/html" /> <link rel="next" href="newglossary004.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="newglossary002.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="newglossary004.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BGBBCFIE" name="BGBBCFIE"></a><a id="ADVRP361" name="ADVRP361"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Filter Columns</h1> <p>Filter columns are an essential component of subquery materialized views. A filter column must be defined in a materialized view log that is supporting a materialized view that references a column in a <code>WHERE</code> clause and is not part of the equi-join.</p> <p>Consider the following DDL:</p> <ol> <li> <p><code>CREATE MATERIALIZED VIEW sales.orders AS</code></p> </li> <li> <p><code>SELECT * FROM sales.orders@dbs1.acme.com o</code></p> </li> <li> <p><code>WHERE EXISTS</code></p> </li> <li> <p><code>(SELECT c_id FROM sales.customers@dbs1.acme.com c</code></p> </li> <li> <p><code>WHERE o.c_id = c.c_id AND zip = 19555);</code></p> </li> </ol> <p>Notice that in line 5 three columns are referenced in the <code>WHERE</code> clause. Columns <code>O.C_ID</code> and <code>C.C_ID</code> are referenced as part of the equi-join clause; the column <code>ZIP</code> is an additional filter column. You will therefore need to create a filter column in the materialized view log for the <code>ZIP</code> column of the <code>SALES.CUSTOMERS</code> table.</p> <p>You are encouraged to analyze the defining queries of your planned materialized views and identify which filter columns will need to be created in your materialized view logs. If you try to create or refresh a materialized view that requires a filter column before creating the materialized view log containing the filter column, your materialized view creation or refresh may fail.</p> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="materialized002.htm#BEIHCICE">Creating Materialized View Logs</a></p> <p><a href="basic_concepts017.htm#CHDGCIGA">Materialized View Logs</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPLN','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication</span></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="newglossary002.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="newglossary004.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