Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\deployment022.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>Instantiate at Remote Materialized View Site: Step 4</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="Instantiate at Remote Materialized View Site: Step 4" /> <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="deployment021.htm" title="Previous" type="text/html" /> <link rel="next" href="configure.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="deployment021.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="configure.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="DAFDBHDH" name="DAFDBHDH"></a><a id="ADVRP279" name="ADVRP279"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Instantiate at Remote Materialized View Site: Step 4</h1> <p>This topic describes how to perform an instantiation at a remote Oracle Enterprise Edition, Oracle Standard Edition, or Oracle Personal Edition site using an instantiation script.</p> <p>The offline instantiation scripts can be generated either manually (see <a href="deployment018.htm#BABDBHBA">Packaging for and Performing for Offline Instantiation</a>) or by using the replication management API (see <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=REPMA','newWindow').focus()"><span class="italic">Oracle Database Advanced Replication Management API Reference</span></a>). To create an instantiation script for online instantiation, you must use the replication management API.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>Oracle Corporation recommends that you test the following instantiation method with the scripts that you have generated before distributing these scripts to your end-users. Additionally, you are encouraged to provide a variation of the following instruction to your end-users with specific information (such as exact script names and script locations). The more testing and information that you provide to your end-users, the better the deployment template instantiation process will proceed.</p> </div> <p>The procedure below applies to both offline and online instantiation of a deployment template.</p> <a id="DAFIDGHB" name="DAFIDGHB"></a><a id="ADVRP420" name="ADVRP420"></a> <p class="subhead2">Instantiate at a Remote Materialized View Site</p> <p>Before the you can begin the instantiation process at the remote materialized view site, make sure that the you have received the generated instantiation scripts. This topic describes using SQL*Plus to perform the instantiation.</p> <p>Perform the following steps at the remote materialized view site:</p> <ol> <li> <p>Start SQL*Plus.</p> </li> <li> <p>Log in to the local database as the owner of the materialized view environment. For example, if <code>HR</code> is the owner of the materialized view objects contained in the deployment template, then connect as <code>HR</code> to the local database.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>If your materialized view database has more than one Oracle database running, then specify the proper host string value when you log in. If you do not know your host string, then contact your database administrator.</p> </div> </li> <li> <p>Execute the script you received from your administrator to set up the materialized view site. To execute the script, enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> SQL> @path/scriptname </pre> <p>For example, if your setup script is named <code>HR_TEMPLATE_setup.sql</code> and it is in the temp directory on the <code>D</code> drive, then enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> SQL> @d:/temp/HR_TEMPLATE_setup.sql </pre> <p>The setup script should only be run once at the materialized view site. If more than one user is instantiating materialized views, then only the first user to run scripts (or the database administrator at the materialized view site) should run the setup script.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>If you have not received a materialized view setup script, then you need to verify that your materialized view site has been setup to support materialized view replication before continuing with Step 4.</p> </div> <div class="helpinfonote"> <p><span class="bold">Note to Administrator: </span>Your users do not need to run a setup script for materialized view sites if you already set up the materialized view sites. <p>To perform a materialized view site setup, the master site must be connected to the materialized view site over a network.</p> <p>See <a href="setting_up002.htm#BABIHGDG">Setting Up Materialized View Sites</a> for information. If you cannot use the wizard, then you must provide the setup script for each materialized view site.</p> </p> </div> </li> <li> <p>Execute the template script you received from your administrator to instantiate the materialized view site. To execute the script, enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> SQL> @path/scriptname </pre> <p>For example, if your script is named <code>HR_TEMPLATE_mydb.world.sql</code> and it is in the temp directory on the <code>D</code> drive, then enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> SQL> @d:/temp/HR_TEMPLATE_mydb.world.sql </pre></li> <li> <p>After you have executed the template script, refresh your materialized view environment (Optional).</p> <p>Refreshing your materialized views requires a network connection and may take some time. If necessary, you can begin using the materialized view sites without refreshing them, and then refresh them later. Refreshing the materialized view sites makes their data current with the associated master tables.</p> <p>Typically, it is important to refresh as soon as possible. The longer the duration between packaging the template and actual instantiation, the greater the amount of changes being stored in the materialized view logs for the materialized views in your deployment template.</p> <p>To refresh the materialized views, execute the refresh script you received from your administrator. Running this script refreshes all of the materialized views created during offline instantiation. To execute the script, enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> SQL> @path/scriptname </pre> <p>For example, if your script is named <code>HR_TEMPLATE_refresh.sql</code> and it is in the temp directory on the <code>D</code> drive, then enter the following:</p> <pre xml:space="preserve" class="oac_no_warn"> SQL> @d:/temp/HR_TEMPLATE_refresh.sql </pre></li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="deployment002.htm#BABIDIHJ">Flowchart for Using Deployment Templates</a></p> </div> </div> <!-- class="sect3" --> <!-- class="sect2" --> <!-- 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="deployment021.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="configure.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