Copyright (c) Oracle Corporation 2004. All Rights Reserved.

# Oracle Workspace Manager - Release 9.2.0.5.0 README

This Workspace Manager 9.2.0.5.0 patch set includes all previous bug fixes. It may be applied to all 9.2.0.x RDBMS releases.

This patch set replaces your existing Oracle Workspace Manager installation. You do not need to apply previous patch sets before applying this patch set.

This README document contains the following information:

- Minimum Installation Requirements
- Installing Workspace Manager
- Upgrading Workspace Manager
- Deinstalling Workspace Manager
- Problems Fixed in This Patch Set

## Minimum Installation Requirements

### Operating Systems

All operating systems supported by Oracle release 9.2.0 and higher are supported by Oracle Workspace Manager.

### Oracle Database Releases: 9.2.0

This patchset must be installed on a 9.2.0.x RDBMS database.

## Installing Workspace Manager

Important Note: If you are upgrading from a previous version of Oracle Workspace Manager, do not follow the instructions in this section; instead follow the upgrade instructions in "Upgrading Workspace Manager".

1. Create a directory (for example, wm_kit) in which to uncompress the Workspace Manager kit. (The remaining instructions and examples assume that this directory is named wm_kit.)
2. Uncompress the source wmkit.zip; that is, unzip the compressed source files to the directory wm_kit.
3. Change the current directory to wm_kit:

    cd wm_kit

4. Start a sqlplus session as the Oracle user SYS:

    sqlplus 'SYS/<SYS_PASSWORD> as sysdba'

(where <SYS_PASSWORD> is the password for the user SYS)
5. Invoke the installation script:

    SQL> @owminst.plb

## Upgrading Workspace Manager

1. Create a directory (for example, wm_kit) in which to uncompress the Workspace Manager kit. (The remaining instructions and examples assume that this directory is named wm_kit.)
2. Uncompress the source wmkit.zip; that is, unzip the compressed source files to the directory wm_kit.
3. Change the current directory to wm_kit:

    cd wm_kit

4. Start a sqlplus session as the Oracle user SYS:

    sqlplus 'SYS/<SYS_PASSWORD> as sysdba'

(where <SYS_PASSWORD> is the password for the user SYS)
5. Invoke the upgrade script:

    SQL> @owmupgrd.plb

The upgrade script automatically determines what version of Oracle Workspace Manager is currently installed and upgrades it to the new version.

## Deinstalling Workspace Manager

Important Notes:

- Deinstalling Oracle Workspace Manager will remove any existing workspaces and the associated metadata.
- Disable versioning on all version-enabled tables in the database before deinstalling Oracle Workspace Manager.

1. Create a directory (for example, wm_kit) in which to uncompress the Workspace Manager kit. (The remaining instructions and examples assume that this directory is named wm_kit.)
2. Uncompress the source wmkit.zip; that is, unzip the compressed source files to the directory wm_kit.
3. Change the current directory to wm_kit:

    cd wm_kit

4. Start a sqlplus session as the Oracle user SYS:

    sqlplus 'SYS/<SYS_PASSWORD> as sysdba'

(where <SYS_PASSWORD> is the password for the user SYS)
5. Invoke the deinstallation script:

    SQL> @owmuinst.plb

## Problems Fixed in This Patch Set

This Patch Set fixes the following problems reported for the 9.2.0.4.0 release of Oracle Workspace Manager:

- Unable to drop a user that has a versioned table using the cascade option. (Bug 4061141)
- Enableversioning can fail when 2 users simultaneously call enableversioning on tables that contain the same user defined type. (Bug 4071978)
- RollbackWorkspace and RemoveWorkspace can fail due to an outdated where clause specified during Lockrows.
- Improved performance of MergeWorkspace and RemoveWorkspace.