Copyright (c) Oracle Corporation
2003. All Rights Reserved.
Oracle Workspace Manager - Release 9.2.0.2.0 README
This Oracle Workspace Manager 9.2.0.2.0 patch set replaces your existing
Oracle Workspace Manager installation. It should be used with the following
supported Oracle Database Releases: 9.2.0.2, 9.1.0.4 and 8.1.7.4.
This README document contains the following information:
Problems Fixed in This Patch Set
This Patch Set fixes the following problems reported for the 9.2.0.1.0
release of Oracle Workspace Manager:
-
When the DBMS_WM.BeginDDL
procedure was used to add an INTEGER column to a version-enabled table,
the scale and precision were not set correctly.
-
When the DBMS_WM.EnableVersioning
procedure was used to version-enable a table and the table contained a
column named "WM'x'" (where 'x' is any character), an exception was raised.
-
When the DBMS_WM.EnableVersioning
procedure was used, performance degradation occurred. This degradation
was more noticeable in a database containing a large number of tables.
The degradation was the result of queries issued by the DBMS_WM.EnableVersioning
procedure against the ALL_NESTED_TABLES view.
- When the "_DIFF" view for a version-enabled table was queried, performance
degradation occurred. The "_DIFF" view was dependent on the SORT_AREA size.
Performance of queries on the view degraded for tables with large numbers
of rows.
-
When the DBMS_WM.MergeTable
procedure was used and the length of the where_clause parameter was 60
characters or more, an exception was raised.
Minimum Installation Requirements
Operating Systems
All operating systems supported by Oracle release 8.1.7 and higher are
supported by Oracle Workspace Manager.
Oracle Database Releases: 8.1.7, 9.0.1, 9.2.0
The minimum supported version of the Oracle database is 8.1.7.
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".
-
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.)
- Uncompress the source wmkit.zip; that is, unzip the compressed source files
to the directory wm_kit.
-
Change the current directory to wm_kit:
cd wm_kit
-
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)
-
Invoke the installation script:
SQL> @owminst.plb
Upgrading Workspace Manager
-
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.)
- Uncompress the source wmkit.zip; that is, unzip the compressed source files
to the directory wm_kit.
-
Change the current directory to wm_kit:
cd wm_kit
-
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)
-
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.
-
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.)
- Uncompress the source wmkit.zip; that is, unzip the compressed source files
to the directory wm_kit.
-
Change the current directory to wm_kit:
cd wm_kit
-
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)
-
Invoke the deinstallation script:
SQL> @owmuinst.plb
|
Bookmark