Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\deployment018.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>Packaging for and Performing for Offline Instantiation</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="Packaging for and Performing for Offline Instantiation" /> <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="deployment017.htm" title="Previous" type="text/html" /> <link rel="next" href="deployment019.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="deployment017.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="deployment019.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABDBHBA" name="BABDBHBA"></a><a id="ADVRP275" name="ADVRP275"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Packaging for and Performing for Offline Instantiation</h1> <p>After you have built your deployment templates, you may want to perform an offline instantiation of a template at each target materialized view site. Offline instantiation allows users to instantiate a template without being connected to the master site through a network. Using offline instantiation, you write all of the necessary DDL and data to a script that you then transfer to the each materialized view site. Then, users run the script at the materialized view site using SQL*Plus. This solution is perfect for laptop users who do not have high-speed network connections, which could make online instantiation difficult.</p> <p>The following scripts are generated:</p> <ul> <li> <p>One setup script. The setup script prepares the materialized view site for replication.</p> </li> <li> <p>One or more template scripts. Each template script creates and populates the objects at the materialized view site. One script is generated for each user in the template.</p> </li> <li> <p>One refresh script. All of the materialized views created by the template scripts are in the same refresh group. Therefore, all users can share the same refresh script. Also, because all of the materialized views are in the same refresh group, refreshing the refresh group refreshes all of the materialized views created by the deployment template.</p> </li> </ul> <div class="helpinfonote"> <p><span class="bold">Note: </span>If conflicts are possible at the master site because of activity at the materialized view sites you are creating, then configure conflict resolution for the master tables of the materialized views before you instantiate the deployment template. <p>See <a href="configure001.htm#CACJABIJ">About Conflict Resolution Methods</a> for more information about configuring conflict resolution.</p> </p> </div> <p>Complete the following steps to start the instantiation process:</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 <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('ADVRP_ADMINISTRATION');"><span class="bold">Manage</span></a>.</p> <p>The Administration Overview page appears.</p> </li> <li> <p>Under the Materialized View Replication, Master Site section, click the number link next to <span class="bold">Templates</span>.</p> <p>The Deployment Templates page appears.</p> </li> <li> <p>From the Name list, select the template that you want to instantiate.</p> </li> <li> <p>Select <span class="bold">Generate Script</span> from the Actions list.</p> </li> <li> <p>Click <span class="bold">Go</span>.</p> <p>The Generate Template Script page appears.</p> </li> </ol> <p>Now, complete the following steps to create offline instantiation scripts:</p> <ol> <li> <p><a href="deployment019.htm#BABEIHJE">Specify Instantiation Users: Step 1</a></p> </li> <li> <p><a href="deployment020.htm#BABJGCFH">Set Refresh Schedule and Select Schemas: Step 2</a></p> </li> <li> <p><a href="deployment021.htm#DAFCJCAD">Distribute Instantiation Scripts: Step 3</a></p> </li> <li> <p><a href="deployment022.htm#DAFDBHDH">Instantiate at Remote Materialized View Site: Step 4</a></p> </li> </ol> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="deployment017.htm#BABFHJFH">Overview of Packaging and Instantiation</a></p> <p><a href="deployment002.htm#BABIDIHJ">Flowchart for Using Deployment Templates</a></p> </div> <!-- 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="deployment017.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="deployment019.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --></div> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de