首页 > Linux操作系统 > Linux操作系统 > Oracle Workspace Manager 组件 说明 .

Oracle Workspace Manager 组件 说明 .

原创 Linux操作系统 作者:grace_xuxj 时间:2012-07-26 15:06:51 0 删除 编辑

一.Workspace Manager 组件说明



SQL> col comp_id for a15

SQL> col version for a15

SQL> col comp_name for a30

SQL> select comp_id,comp_name,versionfrom dba_registry ;


COMP_ID         COMP_NAME                      VERSION

--------------------------------------------- ---------------

XDB             Oracle XML Database  

AMD             OLAP Catalog         

EM              Oracle Enterprise Manager

SDO             Spatial              

ORDIM           Oracle Multimedia    

CONTEXT         Oracle Text          

ODM             Oracle Data Mining   

EXF             Oracle Expression Filter

RUL             Oracle Rules Manager 

OWM             Oracle Workspace Manager

CATALOG         Oracle Database Catalog Views


COMP_ID         COMP_NAME                      VERSION

--------------------------------------------- ---------------

CATPROC         Oracle Database Packages and T11.



JAVAVM          JServer JAVA Virtual Machine

XML            Oracle XDK           

CATJAVA         Oracle Database Java Packages

XOQ             Oracle OLAP API      

APS             OLAP Analytic Workspace


17 rows selected.


MOS 说明:

Oracle 8i/9i/10g/11g 组件(Components) 说明


Oracle WorkspaceManager is a new feature of Oracle 9i that transparently and securely versionsrelational content in place with no changes to application SQL (DML), whilepermitting simultaneous read and write access to the same production data.

--Oracle Workspace Manager 是 Oracle9i 的一个新特性,它使应用程序不必对应用程序的 SQL (DML)进行任何更改,便可将相关内容透明安全地保存在适当位置,而且允许同时对同一生产数据进行读写访问。


Applications usea PL/SQL stored procedure to set users in a workspace. Once in a workspace,changes to data in version-enabled tables (using existing application SQL)create new row versions (within the same tablespace) that are only visiblewithin the workspace until explicitly merged with production data. Or, changescan be rolled back to a specific point in time through the use ofsavepoints. 

--应用程序使用 PL/SQL 存储过程将用户设置到工作区中。一旦在某个工作区更改已启用版本标记的表中的数据(使用现有的应用程序 SQL),则将创建一个新的行版本(在同一个表空间),且新的行版本仅在该工作区内可见,直至其被显式合并到生产数据中。或者可以通过使用保存点将更改及时回滚到指定时间点。


Users in aworkspace always see a transactionally consistent view of the entire database.This means they see the changes made in their workspace plus the rest of thedata in the database as it existed when their workspace was created or sincetheir workspace was last refreshed. 


Use OracleEnterprise Manager or call the Workspace Manager PL/SQL API to version-enabletables and perform. workspace operations, including create, goto workspace, gotodate, merge, refresh, rollback, compare, resolve conflicts and removeworkspace, as well as manage workspace security and locking. 

--使用 Oracle Enterprise Manager 或调用Workspace Manager PL/SQL API,可对表启用版本标记以及执行工作区操作,包括创建、转至工作区、转至日期、合并、刷新、回滚、比较、解决冲突和删除工作区,以及管理工作区安全和锁定。


WorkspaceManager supports Oracle9i, Oracle8i, Oracle Spatial and many Oracle DBMS features,including referential integrity, locking, triggers, import and export.

-- Workspace Manager 支持Oracle 9i,8i,OracleSpatial 和其他的DBMS 特性,包含referential integrity, locking, triggers, import 和export。



WMSYS: It stores data dictionary for OracleWorkspace Manager


可版本化的表(Version-enabling tables)

工作区管理器可以对数据库里面的一个或多个用户表进行版本化,版本化的一个单元是一行。如果一个表是可版本化的,那么表里面的所有行都可以支持数据的多版本。版本化的那一行存储在和源行一样的表里面。所有对行版本的插入、更新和删除操作(DML)都会在Oracle短事务里面进行,以确保版本数据的完整性。版本的基本结构对于数据库的用户来说是不可见的。工作区管理器通过对版本化的表重命名为tablename_LT来实现这种版本化,在重命名的表里面添加一些列来存储版本化的元数据,用源表的名字来创建已版本化的表的一个视图,并且为视图定义一个INSTEAD OF的触发器以方便SQL DML操作。如果你不再需要这个已版本化的表,你可以使这个表的版本化无效。



DatabaseApplication Developer's Guide - Workspace Manager, 10g Release 2 (10.2)



二.卸载Workspace Manager


Note.263428.1 Howto De-install Oracle Workspace Manager



De-installingOracle Workspace Manager will remove any existing workspaces and the associatedmetadata.

卸载Workspace Manager 将会移除任何workspace和关联的metadata。



1)     Disable versioning on allversion-enabled tables in the database before de-installing Oracle WorkspaceManager.


2)     To de-install login to SQL*Plusas SYSDBA, invoke the de-installation script.:
SQL> @$ORACLE_HOME/rdbms/admin/owmuinst.plb

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



三.安装Workspace Manager


Howto install Workspace Manager with Custom Databases 11gR1
Installing WorkspaceManager with Custom Databases 11gR2


WorkspaceManager is installed by default in the seed database and in all databasescreated by the Database Configuration Assistant (DBCA). However, in all otherOracle databases, such as those you create with a customized procedure, youmust install Workspace Manager before you can use its features.

--默认情况下,Workspace Manager 是安装的,如果我们是自己定制的安装过程中没有安装OWM,那么就需要手工的来安装。


To install WorkspaceManager in a custom database, do the following:

(1)At the system command prompt,change the current directory to the directory that contains Workspace Managerinstallation script. and packages, as shown in the following example:



(2)Connect as SYS to theOracle instance with a command in the following format:

sqlplus sys

Enter thepassword for the SYS account when you are prompted.


(3)Run the owminst.plb script.:

SQL> @owminst.plb


(4)Verify the installation ofWorkspace Manager by entering the following command while connected as anyvalid database user, and ensure that the output is as shown here:

SQL> select dbms_wm.getWorkspace fromdual;







四. 其他问题:


4.1 Workspace Manager  版本问题

Note.341353.1 Whydoes the Workspace Manager version differ from the current RDBMS patchsetversion 


In V9.2.x toV10.2.x, the Oracle Workspace Manager updates are not integrated with thegeneric RDBMS patchsets, but are released seperately.

--在Oracle 9i 到10g中,OWM 的更新不是和RDBMSPatchsets一起的,需要独立的update OWM。


You will need toobtain the latest available Workspace Manager patchset from Metalink:



Steps to find the patchset:


Go to

Patches & Updates
Advanced Search
Product or Product Family : Workspace Manager
Release : 9.2.0.x or 10.1.0.x or 10.2.0.x

Install thehighest available Workspace Manager Patchset for your 9.2.0 or 10.1.0 or 10.2.0release. Follow the instructions described in the README.


From Oracle 11g onwards,the Oracle Workspace Manager updates are integrated with the generic RDBMSpatchsets.

--注意,从Oracle11g 以后,OWM的更新和RDBMSPatchset一起,不需要在单独的更新OWM。


4.2 Workspace Manager 常见问题

Note.156963.1 FrequentlyAsked Questions for Oracle Workspace Manager 

4.2.1 How Does Workspace Manager Work?

The WorkspaceManager API is implemented as PL/SQL packages, automatically installed withOracle9i. Using the API or the Version Enabled Tables folder in OracleEnterprise Manager, one can selectively version-enable some or all tables in anexisting or new database. There can be a hierarchy of workspaces in thedatabase. By default, when a workspace is created, it is created from thetopmost, or LIVE, database workspace.


All changes madein a workspace are made by conventional short transactions. Creating anexplicit savepoint causes a new version of a row to be created the next timethe row is updated. Changes made in one or more workspaces to the sameproduction data are captured automatically as new versions of the data. Storageexpansion and row proliferation is minimized by versioning only changed rowsand by placing the new versions in the same tablespace.


Conflicts aredetected automatically before changes are merged into the LIVE workspaceand can be resolved by the user with Oracle Enterprise Manager orprogrammatically through the API. 



4.2.2 Summary of Enterprise Manager Integration:

While connectedto a database, you will see a folder called Workspace Management that can beexpanded to see two sub-folders: Version Enabled Tables and Workspaces.

(1)    The OEM Version Enabled tablessub-folder allows you to view table status and set tables as version-enabled.

(2)    The OEM Workspaces folderallows you to:

1)Create and view workspace hierarchies and attributes, including:

2)Set and view workspace access modes. The user access modes for aworkspace are:

a)       No access, is the default

b)       Read only

c)       Single writer, allowing allother users to read

d)      Workspace operations only, suchas merge and rollback

3)Set and view Savepoints

a)       Implicit savepoint created bythe system when child workspace is created

b)       Explicit savepoint created by auser

4)Rollback changes since last explicit savepoint

5)Resolve differences between any two workspaces or between twosavepoints in a workspace

6)Refresh an entire workspace, a table, or rows with data from theparent workspace. Refreshing a workspace may not succeed if there are conflicts

7)Merge all changes made in the workspace or changes made to aspecific table.

8)Set Privileges to access, create, delete, rollback and mergeworkspaces


4.2.3 Summary of Workspace Manager metadata views:

WorkspaceManager creates and maintains metadata views to hold information that helps tomanage the workspace environment and diagnose problems. These views areread-only to users. Views that span the whole workspace environment are:



(3)    USER_WORKSPACES and ALL_WORKSPACES containinformation on the workspaces user owns or can access


(5)    USER_WORKSPACE_PRIVS and ALL_WORKSPACE_PRIVS includesall users' privileges

(6)    USER_WM_PRIVS includesprivileges the current user has in each workspace



(9)    DBA_WORKSPACE_USERS containsuser info for workspaces other than LIVE

(10) USER_WM_RIC_INFO and ALL_WM_RIC_INFO containreferential integrity constraints


(12) ALL_VERSION_HVIEW is a workspace hierarchy


Views created for eachworkspace enabled table are:

(1)    Conflict view

(2)    Difference view

(3)    Lock view

(4)    History view

(5)    Multiworkspace view







来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: 搭建rman备份平台
请登录后发表评论 登录


  • 博文量
  • 访问量