In this Document

APPLIES TO:

Workspace Manager - Version 9.0.1.0 to 12.1.0.1 [Release 9.0.1 to 12.1]
Information in this document applies to any platform.
Checked for Relevance on 30-May-2014.

GOAL

This article is for DBAs and explains how to install/deinstall Oracle Workspace Manager.

SOLUTION

The scripts to install/deinstall Workspace Manager are as follows:

DEINSTALL

1. Disable versioning on all version-enabled tables in the database before de-installing Oracle Workspace Manager.  To verify if you have any currently version-enabled tables in your database:

From SQL*Plus connected to the database as a DBA user, enter:

Once you have confirmed you have no versioned tables, or the count read 0, then you can proceed with the deinstall.

2. To uninstall Workspace Manager, run the following script, as SYS:

INSTALL

If you wish to reinstall Workspace Manager at a later time, you can run, as SYS:

The Install / Upgrade / De-install process is also discussed in the readme included in the kit. The readme is supplied with Workspace Manager patch kits.

These scripts can be run at any time without having to bounce the database, as long as OWM is not being used.

REFERENCES

NOTE:727765.1 - How to Determine if Workspace Manager is Being Used?
NOTE:358825.1 - Oracle Workspace Manager Does Not Remove Completely