Contents

Title and Copyright Information

List of Examples

List of Figures

List of Tables

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Organization

Related Documentation

Conventions

New and Changed Features

DDL Support Related to Version-Enabled Tables

Replication Support for Workspace Manager

Migration Support Procedures

Session Context Information

Synonym Support for Table Names

Multilevel Referential Integrity Support

New Privileges: FREEZE_WORKSPACE and FREEZE_ANY_WORKSPACE

WM_INSTALLATION View

STATE Column added to xxx_WM_VERSIONED_TABLES Views

New Columns Added to xxx_WORKSPACES Views

New Columns Added to xxx_WORKSPACE_SAVEPOINTS Views

"Ignore Last Error" Option

FreezeWorkspace Options

CompressWorkspace Options and Behavior Changes

1 Introduction

1.1 Workspace Manager Overview

1.1.1 Workspace Hierarchy

1.1.2 Using Savepoints

1.1.2.1 Design Issue: Savepoint or Child Workspace?

1.1.3 Merging and Rolling Back Workspace Changes

1.1.4 Resolving Conflicts Before a Merge or Refresh Operation

1.1.5 Freezing and Unfreezing Workspaces

1.1.6 Removing Workspaces

1.1.7 Autocommitting of Workspace Manager Operations

1.1.8 Infrastructure for Version-Enabling of Tables

1.1.9 Workspace Manager Schema, Metadata, and Package

1.2 Session Context Information

1.3 Lock Management

1.4 Privilege Management

1.5 Import and Export Considerations

1.6 DDL Operations Related to Version-Enabled Tables

1.7 Referential Integrity Support

1.8 Triggers on Version-Enabled Tables

1.9 Support for Table Synonyms

1.10 Procedure Categories

1.10.1 Table Management Procedures

1.10.2 Workspace Management Procedures

1.10.3 Savepoint Management Procedures

1.10.4 Privilege Management Procedures

1.10.5 Lock Management Procedures

1.10.6 Conflict Management Procedures

1.10.7 Replication Support Procedures

1.11 Simplified Example

2 Procedures: Reference

AlterSavepoint

AlterWorkspace

BeginDDL

BeginResolve

CommitDDL

CommitResolve

CompressWorkspace

CompressWorkspaceTree

CopyForUpdate

CreateSavepoint

CreateWorkspace

DeleteSavepoint

DisableVersioning

DropReplicationSupport

EnableVersioning

FreezeWorkspace

GenerateReplicationSupport

GetConflictWorkspace

GetDiffVersions

GetLockMode

GetMultiWorkspaces

GetOpContext

GetPrivs

GetSessionInfo

GetWorkspace

GotoDate

GotoSavepoint

GotoWorkspace

GrantSystemPriv

GrantWorkspacePriv

IsWorkspaceOccupied

LockRows

MergeTable

MergeWorkspace

RecoverAllMigratingTables

RecoverMigratingTable

RefreshTable

RefreshWorkspace

RelocateWriterSite

RemoveWorkspace

RemoveWorkspaceTree

ResolveConflicts

RevokeSystemPriv

RevokeWorkspacePriv

RollbackDDL

RollbackResolve

RollbackTable

RollbackToSP

RollbackWorkspace

SetConflictWorkspace

SetDiffVersions

SetLockingOFF

SetLockingON

SetMultiWorkspaces

SetWoOverwriteOFF

SetWoOverwriteON

SetWorkspaceLockModeOFF

SetWorkspaceLockModeON

SynchronizeSite

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_WM_VT_ERRORS

3.8 ALL_WORKSPACE_PRIVS

3.9 ALL_WORKSPACE_SAVEPOINTS

3.10 ALL_WORKSPACES

3.11 DBA_WORKSPACE_SESSIONS

3.12 ROLE_WM_PRIVS

3.13 USER_WM_LOCKED_TABLES

3.14 USER_WM_MODIFIED_TABLES

3.15 USER_WM_PRIVS

3.16 USER_WM_RIC_INFO

3.17 USER_WM_TAB_TRIGGERS

3.18 USER_WM_VERSIONED_TABLES

3.19 USER_WM_VT_ERRORS

3.20 USER_WORKSPACE_PRIVS

3.21 USER_WORKSPACE_SAVEPOINTS

3.22 USER_WORKSPACES

3.23 WM_INSTALLATION

3.24 WM_REPLICATION_INFO

3.25 xxx_CONF Views

3.26 xxx_DIFF Views

3.27 xxx_LOCK Views

3.28 xxx_HIST Views

3.29 xxx_MW Views

A Installing Workspace Manager with Custom Databases

B Migrating to Another Workspace Manager Release

B.1 Upgrading to the Current Release

B.2 Downgrading to a Previous Release

C Using Replication with Workspace Manager

C.1 Setting Up Replication with Workspace Manager

C.2 Enabling and Disabling Versioning of Tables with Replication Support

C.3 DDL Operations with Replicated Version-Enabled Tables

C.4 Relocating the Writer Site

D Error Messages

Glossary

Index