Install a Work Area in Oracle DMW

You can install Work Areas on the Workareas screen, accessed from the Workareas for selected Study icon on the Home page after selecting a Study.

1. On the Home page, select a Study.
2. Click the Workareas for selected Study icon.
   You are taken to the Workareas screen. The Work Areas related to the selected study and lifecycle are listed in the top part of the page.
3. To narrow the list of Work Areas, you can search by Data Model name using the search function in the upper right corner of the screen.
4. Click the name of the Work Area in the grid to select it.
   The object instances associated with the Work Area load in the bottom half of the screen.
5. Select Install from the Actions drop down menu in the Workareas section of the page.
   The Workarea Install window is displayed, showing a list of object instances in the Work Area and different installation options.
6. Select an Install Mode:
   • Upgrade: This installation compares the Work Area's installed objects to the current objects and adds new objects and replaces objects that have changed—except for Table instances, which are always upgraded rather than replaced to preserve all data.
   • Partial: Partial Installation Mode allows you to specify the action you want the installation job to take on the objects you include in the installation, including explicitly dropping objects. For each table you can specify whether to replace or upgrade the table; if you choose to replace it, the system deletes its data; if you choose to upgrade it, the system upgrades the table to the new version without deleting its data.
   • Full: This installation mode drops and replaces the entire set of schemas. All objects—including tables, checked-out objects, and any objects whose Omitted flag is checked but have been previously installed—are dropped, replaced, and checked in. Full installation deletes all data.
7. Select the Force Script Regeneration checkbox to generate 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.
8. In the bottom portion of the screen where the object instances are listed, you can select which object instances you would like to install by checking the boxes in the Install column.

   Note:

   You can only select object instances if you have chosen the Upgrade or Partial Installation Mode.
9. If you have selected Partial Installation Mode, you can click the link in the Action column for each object to choose whether you want to Upgrade Object (preserve the old data) or Replace Object (install the new object and delete the data from the previous version).
10. Click the Install button to begin the Work Area installation.