Running a Work Area Installation

To install a Work Area and one or more of the objects it contains, go to the Work Area and do the following:

1. Click Installation in the Properties screen of the Work Area you want to install. The system displays the Work Area Installation screen.

2. Choose a mode of installation. See Installation Modes for further information.

   • Full installation drops and replaces the entire schema with all objects, including tables, deleting all data.

   • Upgrade installation automatically add and replaces only objects that are new or changed since the last successful installation, and always upgrades tables, rather than deleting them, so that it does not delete data.

   • Partial installation allows you to specify which objects you want to install and what action you want the installation job to take on the objects you include.

     Note:

     To safeguard data, Oracle LSH allows only nondestructive installation modes in Work Areas with a Usage Intent of Production. You can use Upgrade mode or Partial mode, but in Partial mode Table instances must have Upgrade as their assigned action.

3. In the Install Actions drop-down list, select Process Current Installation to Completion. This is the only option currently available.

   Choose whether or not to view the installation scripts before committing the changes to the database. The scripts list the object instances to be installed with the DDL scripts detailing the actions to be taken...There's a list of Install Actions in the FDD

4. Choose whether or not to run a batch install:

   • If you select Batch Install, the system runs the installation as a batch process. The installation job is placed on a queue and the system returns control of the UI to the user. You can abort the installation if necessary.

   • If you do not select Batch Install, the system runs the installation in interactive mode. The installation job does not go onto a queue and therefore can run more quickly than in batch mode. However, you cannot do anything else in Oracle LSH until the installation has completed. You cannot abort the installation. Interactive mode is appropriate when you are installing a small number of objects.

5. Choose whether or not to Force Script Regeneration. During installation, the system generates two sets of scripts for objects that have changed since the last successful installation:

   • DDL scripts for each object included in the installation. The system uses these scripts to create the actual schema objects during installation.

   • Scripts to be used at runtime for some of the objects; for example, a SAS script for a SAS-based Program that establishes the appropriate SAS views for accessing Oracle LSH data.

   If you select this option, the system generates new scripts for all objects in the installation, even if they have not changed. All objects are either replaced or, if they are Tables, upgraded. This is useful if your schema has become corrupted and you want to recreate all objects without losing any data.

   Checking this attribute has an effect only in Upgrade mode. In Full mode the system always regenerates scripts for every object regardless of the setting of this attribute. In Partial mode the system uses the action you specify in the Actions column for each object to determine whether to regenerate the scripts.

6. Review the objects to be installed. You can sort the objects in the Work Area by clicking most of the column headings, including: Name, Type, Installable, Upgradable, Definition Checked Out By, and Current Version Installed?.

7. Check the box in the Omitted column for each object you want to omit from the installation. The system automatically checks this box for objects whose status is Non Installable. You can also use the Omit All and Omit None buttons.

   You can omit any object in any installation mode and, if the object you omit has never been installed, it will be truly excluded from the installation process. However, if it has already been installed, the system takes a different action depending on the installation mode:

   • Full. In Full mode, the installation process drops the object and replaces it with the same version that was already installed. If a Table instance has already been installed and you run a Full installation on its Work Area, the system drops and replaces the Table instance and deletes all its data, even if you check its Omitted checkbox.

   • Upgrade. In Upgrade mode, objects marked as Omitted are not installed.

   • Partial. In Partial mode, when you check an object's Omitted checkbox, the system automatically sets the Action for the object to No Action. If you leave Action set to No Action, the object is omitted. If you change this setting, the installation does not omit the object, but performs the action you specify.

     Note:

     Objects with a value of No in the Installable column are automatically omitted from the installation in all modes.

8. To save your changes but install later, click Apply.

   To install now, click Apply and Install.

   Note:

   Before the installation can begin, the system must wait for all job executions of Work Area Programs, Load Sets, Report Sets, or Workflows currently running to complete. The system prevents new jobs from starting.