Workspace Management

Workspace Management

Workspace management is new in 9i. This feature allows you to version-enable tables, so that different users can have their own private versions of tables. Oracle internally keeps track of changes to different workspaces and you must resolve any update conflicts prior to merging them. Here are the steps to using workspace management:

1. Version-enable one or more tables
2. Create workspaces
3. Grant privileges
4. Access and use the workspace
5. Resolve conflicts between original and versioned rows
6. Refresh/merge workspaces
7. Disable versioning tables
8. Remove workspaces

Versioning-enabling works on the unit of a table. Different workspaces contain different table versions. A version-enabled table has the suffix _LT appended to its regular name.

You can only refresh or merge table versions after you have resolved any data conflicts (different row data) between them. Oracle provides package DBMS_WM and the new role WM_ADMIN_ROLE to manage the new workspace feature. Workspace management is installed by default, or login as user SYS and run OWMINST.PLB.