Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpii\tdpii_reppit006.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>Configuring Materialized View Sites</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="Configuring Materialized View Sites" /> <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_reppit005.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpii_reppit007.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_reppit005.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_reppit007.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDBCGBG" name="CHDBCGBG"></a><a id="TDPII105" name="TDPII105"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1>Configuring Materialized View Sites<a id="sthref416" name="sthref416"></a><a id="sthref417" name="sthref417"></a><a id="sthref418" name="sthref418"></a></h1> <a name="BEGIN" id="BEGIN"></a> <p>Before you configure materialized views, you must configure the databases that will function as materialized view sites in your replication environment. Completing the steps in this topic will configure the necessary users and database links required by the materialized view environment. In addition, if you plan to configure updatable materialized views, then these steps also configure scheduled links and scheduled purges for changes made to updatable materialized views.</p> <p class="orderedlisttitle">To configure materialized view sites with Enterprise Manager: </p> <ol> <li><a id="CHDCBHID" name="CHDCBHID"></a> <p>Complete the actions described in <a href="tdpii_reppit005.htm#CHDIHIFJ">"Preparing for Materialized View Replication"</a>.</p> </li> <li><a id="CHDJDECC" name="CHDJDECC"></a> <p>In Oracle Enterprise Manager, log in to the materialized view site as an administrative user, such as <code>SYSTEM</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><a id="CHDDIBHA" name="CHDDIBHA"></a> <p>Click <span class="bold">Setup</span> in the Advanced Replication section.</p> </li> <li> <p>On the Advanced Replication: Setup page, expand <span class="bold">Updateable Materialized View Replication</span>.</p> </li> <li> <p>Select <span class="bold">Configure Materialized View Sites for Replication</span>.</p> </li> <li><a id="CHDHJHDD" name="CHDHJHDD"></a> <p>Click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('ADVRP_CONFIG_MV');"><span class="bold">Continue</span></a> to open the Configure Materialized View Sites for Replication Wizard.</p> <p>Complete the pages in the wizard to configure the materialized view sites. On the Create Users page, enter an appropriate password for the materialized view administrator. See <a href="topicid:TDPSG20022">Requirements for Creating Passwords</a> for information about choosing passwords. For more information about using the wizard, click <span class="bold">Help</span> for each page of the wizard.</p> <div class="helpinfonote"> <p><span class="bold">Tip: </span>On the Create Schemas page of the wizard, make sure you select the schemas that contain the database objects that you want to replicate.</p> </div> <p>When you finish the wizard, an Enterprise Manager job is scheduled to configure the materialized view sites. After the job runs successfully, the materialized view sites are configured, and each one has a materialized view administrator. By default, the user name of the materialized view administrator is <code>mvadmin</code>. You specified the password for this user when you completed the wizard. Also, each materialized view site contains each schema that you specified on the Create Schemas page of the wizard.</p> </li> <li> <p><a id="sthref420" name="sthref420"></a>At each materialized view site, create the required database links for the replicated schemas.</p> <p>To create materialized views in a schema at the materialized view site, the schema must be able to connect to the corresponding schema at the master site through a database link.</p> <p>To create the database links:</p> <ol> <li><a id="CHDCFDHF" name="CHDCFDHF"></a> <p>On a command line, open SQL*Plus and connect to the materialized view database as the owner of the replicated schema.</p> <p>For example, if you plan to create materialized views in the <code>hr</code> schema at the <code>ii2.example.com</code> database, then enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> sqlplus hr@ii2.example.com Enter password: <span class="italic">password</span> </pre> <p>See <a href="topicid:ADMQS0361">Starting SQL*Plus and Connecting to the Database</a> for more information about starting SQL*Plus.</p> </li> <li><a id="CHDIHBAF" name="CHDIHBAF"></a> <p>Create a database link that connects to the corresponding replicated schema at the master database.</p> <p>For example, to create a database link that connects to the <code>hr</code> schema at the <code>ii1.example.com</code> database, enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> CREATE DATABASE LINK ii1.example.com CONNECT TO hr IDENTIFIED BY <span class="italic">password</span> USING 'ii1.example.com'; </pre></li> <li><a id="CHDGDICJ" name="CHDGDICJ"></a> <p>Repeat Steps <a href="#CHDCFDHF">a</a> through <a href="#CHDIHBAF">b</a> for each replicated schema at the materialized view database.</p> </li> <li> <p>Repeat Steps <a href="#CHDCFDHF">a</a> through <a href="#CHDGDICJ">c</a> for each materialized view database.</p> </li> </ol> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpii_intro2ii005.htm#CFHBIEHG">When to Replicate Data with 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_reppit008.htm#BEHDACAG">Replicating Read-Only Data Using Materialized Views</a></p> <p><a href="tdpii_reppit011.htm#BEHCEFGC">Replicating Read/Write Data Using Materialized Views</a></p> <p><a href="tdpii_reppit.htm#BEHHGGIB">Replicating Data Using Materialized Views</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 © 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_reppit005.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpii_reppit007.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