Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\advrp\deployment020.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>Set Refresh Schedule and Select Schemas: Step 2</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="Set Refresh Schedule and Select Schemas: Step 2" /> <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="deployment019.htm" title="Previous" type="text/html" /> <link rel="next" href="deployment021.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="deployment019.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="deployment021.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABJGCFH" name="BABJGCFH"></a><a id="ADVRP277" name="ADVRP277"></a></p> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h1>Set Refresh Schedule and Select Schemas: Step 2</h1> <p>Complete the following steps to set the refresh schedule and select schemas:</p> <ol> <li> <p>If necessary, use the <span class="bold">Refresh Schedule</span> section to modify the scheduling characteristics for the refresh group created by the instantiation of the deployment template. All of the materialized views are placed in this refresh group during instantiation. Therefore, all of the materialized views are refreshed at the same time according to the schedule you specify:</p> <ul> <li> <p>In the Start Date field, either enter a new start date or use the date icon to specify a new start date.</p> <p>The start date is the date on which the materialized views in the template are first refreshed.</p> </li> <li> <p>In the Every field, specify a new interval.</p> <p>The interval is the amount of time between refreshes.</p> </li> <li> <p>In the Time field, specify the time the new refresh starts.</p> </li> </ul> </li> <li> <p>The Schemas section lets you specify which schemas the generated setup script should create at the materialized view site. Add all of the schemas that own the objects included in the template to the Selected Schemas list.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>You must add all of these schemas even if they already exist at the materialized view site.</p> </div> <ul> <li> <p>Select the schemas in the Available Schemas list.</p> </li> <li> <p>Click the right arrow to add the selected users to the Selected Schemas list.</p> </li> </ul> </li> <li> <p>Click <span class="bold">Generate Script</span> to save the generated script.</p> <p>When you click <span class="bold">Generate Script</span> on this page, a setup script is generated for the materialized view site along with a refresh script that is used to refresh all of the instantiated materialized views.</p> <p>When you specify the location for the template scripts, a template script is generated for each user that you selected earlier. In the directory you specify, the wizard creates one subdirectory for each user you specified. So, if you specified <code>HR</code> and <code>OE</code> as users, then two folders are created: one named <code>HR</code> and one named <code>OE</code>. In each folder is the offline instantiation script for the user. The name of the script is <code><span class="codeinlineitalic">templatename</span></code>_<code>sitename.sql</code>. For example, if the template name is <code>SALES</code> and the site name is <code>SDB.WORLD</code>, the script name is <code>SALES_SDB.WORLD.sql</code>.</p> </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" --> <!-- 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="deployment019.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="deployment021.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