Set Refresh Schedule and Select Schemas: Step 2

Complete the following steps to set the refresh schedule and select schemas:

1. If necessary, use the Refresh Schedule 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:

   • In the Start Date field, either enter a new start date or use the date icon to specify a new start date.

     The start date is the date on which the materialized views in the template are first refreshed.

   • In the Every field, specify a new interval.

     The interval is the amount of time between refreshes.

   • In the Time field, specify the time the new refresh starts.

2. 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.

   Note: You must add all of these schemas even if they already exist at the materialized view site.

   • Select the schemas in the Available Schemas list.

   • Click the right arrow to add the selected users to the Selected Schemas list.

3. Click Generate Script to save the generated script.

   When you click Generate Script 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.

   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 HR and OE as users, then two folders are created: one named HR and one named OE. In each folder is the offline instantiation script for the user. The name of the script is templatename_sitename.sql. For example, if the template name is SALES and the site name is SDB.WORLD, the script name is SALES_SDB.WORLD.sql.