Contents

Title and Copyright Information

List of Examples

List of Figures

List of Tables

Send Us Your Comments

Preface

1 Introduction

1.1 Workspace Management

1.2 Workspace Concepts and Operations

1.2.1 Hierarchy of Workspaces

1.2.2 Using Savepoints

1.2.3 Merging and Rolling Back Workspace Changes

1.2.4 Autocommitting of Workspace Manager Operations

1.2.5 Resolving Conflicts

1.2.6 Freezing and Unfreezing Workspaces

1.2.7 Removing Workspaces

1.3 Lock Management

1.4 Privilege Management

1.5 Import and Export Considerations

1.6 Referential Integrity Support

1.7 Triggers on Version-Enabled Tables

1.8 Procedure Categories

1.8.1 Table Management

1.8.2 Workspace Management

1.8.3 Savepoint Management

1.8.4 Privilege Management

1.8.5 Lock Management

1.8.6 Conflict Management

1.9 Simplified Example

2 Procedures: Reference

AlterSavepoint

AlterWorkspace

BeginResolve

CommitResolve

CompressWorkspace

CompressWorkspaceTree

CopyForUpdate

CreateSavepoint

CreateWorkspace

DeleteSavepoint

DisableVersioning

EnableVersioning

FreezeWorkspace

GetConflictWorkspace

GetDiffVersions

GetLockMode

GetMultiWorkspaces

GetOpContext

GetPrivs

GetWorkspace

GotoDate

GotoSavepoint

GotoWorkspace

GrantSystemPriv

GrantWorkspacePriv

IsWorkspaceOccupied

LockRows

MergeTable

MergeWorkspace

RefreshTable

RefreshWorkspace

RemoveWorkspace

RemoveWorkspaceTree

ResolveConflicts

RevokeSystemPriv

RevokeWorkspacePriv

RollbackResolve

RollbackTable

RollbackToSP

RollbackWorkspace

SetConflictWorkspace

SetDiffVersions

SetLockingOFF

SetLockingON

SetMultiWorkspaces

SetWoOverwriteOFF

SetWoOverwriteON

SetWorkspaceLockModeOFF

SetWorkspaceLockModeON

UnfreezeWorkspace

UnlockRows

3 Metadata Views

3.1 ALL_VERSION_HVIEW

3.2 ALL_WM_LOCKED_TABLES

3.3 ALL_WM_MODIFIED_TABLES

3.4 ALL_WM_RIC_INFO

3.5 ALL_WM_TAB_TRIGGERS

3.6 ALL_WM_VERSIONED_TABLES

3.7 ALL_WORKSPACE_PRIVS

3.8 ALL_WORKSPACE_SAVEPOINTS

3.9 ALL_WORKSPACES

3.10 DBA_WORKSPACE_SESSIONS

3.11 ROLE_WM_PRIVS

3.12 USER_WM_LOCKED_TABLES

3.13 USER_WM_MODIFIED_TABLES

3.14 USER_WM_PRIVS

3.15 USER_WM_RIC_INFO

3.16 USER_WM_TAB_TRIGGERS

3.17 USER_WM_VERSIONED_TABLES

3.18 USER_WORKSPACE_PRIVS

3.19 USER_WORKSPACE_SAVEPOINTS

3.20 USER_WORKSPACES

3.21 xxx_CONF Views

3.22 xxx_DIFF Views

3.23 xxx_LOCK Views

3.24 xxx_HIST Views

3.25 xxx_MW Views

A Installing Workspace Manager with Custom Databases

B Error Messages

Glossary

Index