Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Organization

Related Documentation

Conventions

What's New in Workspace Manager?

where_clause Parameter and Subqueries

New Valid Time Procedures

MP_ROOT_WORKSPACE Column in xxx_WORKSPACES Views

DBA_WM_VT_ERRORS View

auto_commit Parameter Added to SetWorkspaceLockModeOn and SetWorkspaceLockModeOff Procedures

Parameters Removed for SetValidTime Procedure

Dropping Users with Version-Enabled Tables

DDL Operations and Table-Level Privileges

Part I Conceptual and Usage Information

1 Introduction to Workspace Manager

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 Using Workspace Manager Events

1.1.8 Autocommitting of Workspace Manager Operations

1.1.9 Continually Refreshed Workspaces

1.1.10 Multiparent Workspaces

1.1.11 Infrastructure for Version-Enabling of Tables

1.1.12 Workspace Manager Schema, Metadata, and Package

1.2 Session Context Information for Workspace Manager

1.3 Lock Management with Workspace Manager

1.3.1 Exclusive Locking and Row Versions

1.4 Privilege Management with Workspace Manager

1.5 System Parameters for Workspace Manager

1.6 Import and Export Considerations

1.7 Bulk Loading into Version-Enabled Tables

1.8 DDL Operations Related to Version-Enabled Tables

1.9 Constraint Support with Workspace Manager

1.9.1 Referential Integrity Support

1.9.2 Unique Constraints

1.10 Triggers on Version-Enabled Tables

1.11 Virtual Private Database Considerations

1.12 Support for Table Synonyms

1.13 Materialized View Support

1.14 Spatial Topology Support

1.14.1 Locking Considerations with Topologies

1.14.2 Additional Considerations with Topologies

1.15 Reserved Words and Characters

1.16 DBMS_WM Subprogram Categories

1.16.1 Table Management Subprograms

1.16.2 Workspace Management Subprograms

1.16.3 Savepoint Management Subprograms

1.16.4 Privilege Management Subprograms

1.16.5 Lock Management Subprograms

1.16.6 Conflict Management Subprograms

1.16.7 Replication Support Subprograms

1.16.8 Bulk Load Support Subprograms

1.17 Simplified Examples Using Workspace Manager

1.17.1 Example: Marketing Budget Options

1.17.2 Example: Warehouse Expansion Options

2 Workspace Manager Events

2.1 List of Workspace Manager Events

2.2 Event Parameters

2.3 ALLOW_CAPTURE_EVENTS System Parameter

2.4 AQ Operations and Workspace Manager Events

2.4.1 Workspace Manager Event Queue Administration

2.4.2 Privileges and Access Control for Queues

2.4.3 Rule-Based Subscription

2.4.4 Listening for Events

2.4.5 Asynchronous Notification

3 Workspace Manager Valid Time Support

3.1 Valid Time Support: Introduction and Example

3.2 WM_PERIOD Data Type

3.3 Valid Time Constants

3.4 API Features for Valid Time Support

3.5 Operators for Valid Time Support

3.5.1 WM_CONTAINS

3.5.2 WM_EQUALS

3.5.3 WM_GREATERTHAN

3.5.4 WM_INTERSECTION

3.5.5 WM_LDIFF

3.5.6 WM_LESSTHAN

3.5.7 WM_MEETS

3.5.8 WM_OVERLAPS

3.5.9 WM_RDIFF

3.6 Queries and DML Operations with Valid Time Support

3.6.1 Queries

3.6.2 Data Manipulation (DML) Operations

3.6.2.1 Update Operations

3.6.2.2 Insert Operations

3.7 Constraint Management for Valid Time Support

3.7.1 Referential Integrity Constraints

3.7.2 Unique Constraints

3.8 Locking with Valid Time Support

3.9 Metadata Views Affected by Valid Time Support

3.9.1 xxx_CONF Views and Valid Time Support

3.9.2 xxx_DIFF Views and Valid Time Support

3.9.3 xxx_HIST Views and Valid Time Support

3.9.4 xxx_LOCK Views and Valid Time Support

3.9.5 xxx_MW Views and Valid Time Support

3.10 SQL* Loader Support for Valid Times

3.11 Adding Valid Time Support to an Existing Table

Part II Reference Information

4 DBMS_WM Package: Reference

Add_Topo_Geometry_Layer

AddAsParentWorkspace

AlterSavepoint

AlterVersionedTable

AlterWorkspace

BeginBulkLoading

BeginDDL

BeginResolve

ChangeWorkspaceType

CommitBulkLoading

CommitDDL

CommitResolve

CompressWorkspace

CompressWorkspaceTree

CopyForUpdate

CreateSavepoint

CreateWorkspace

Delete_Topo_Geometry_Layer

DeleteSavepoint

DisableVersioning

DropReplicationSupport

EnableVersioning

Export

FindRICSet

FreezeWorkspace

GenerateReplicationSupport

GetBulkLoadVersion

GetConflictWorkspace

GetDiffVersions

GetLockMode

GetMultiWorkspaces

GetOpContext

GetPhysicalTableName

GetPrivs

GetSessionInfo

GetSystemParameter

GetValidFrom

GetValidTill

GetWMMetadataSpace

GetWorkspace

GotoDate

GotoSavepoint

GotoWorkspace

GrantGraphPriv

GrantSystemPriv

GrantWorkspacePriv

Import

IsWorkspaceOccupied

LockRows

MergeTable

MergeWorkspace

Move_Proc

RecoverAllMigratingTables

RecoverFromDroppedUser

RecoverMigratingTable

RefreshTable

RefreshWorkspace

RelocateWriterSite

RemoveAsParentWorkspace

RemoveWorkspace

RemoveWorkspaceTree

ResolveConflicts

RevokeGraphPriv

RevokeSystemPriv

RevokeWorkspacePriv

RollbackBulkLoading

RollbackDDL

RollbackResolve

RollbackTable

RollbackToSP

RollbackWorkspace

SetCaptureEvent

SetCompressWorkspace

SetConflictWorkspace

SetDiffVersions

SetLockingOFF

SetLockingON

SetMultiWorkspaces

SetSystemParameter

SetTriggerEvents

SetValidTime

SetWMValidTimeFilterOFF

SetWMValidTimeFilterON

SetWMValidUpdateModeOFF

SetWMValidUpdateModeON

SetWoOverwriteOFF

SetWoOverwriteON

SetWorkspaceLockModeOFF

SetWorkspaceLockModeON

SynchronizeSite

UnfreezeWorkspace

UnlockRows

UseDefaultValuesForNulls

5 Workspace Manager Metadata Views

5.1 ALL_MP_GRAPH_WORKSPACES

5.2 ALL_MP_PARENT_WORKSPACES

5.3 ALL_VERSION_HVIEW

5.4 ALL_WM_CONS_COLUMNS

5.5 ALL_WM_CONSTRAINTS

5.6 ALL_WM_IND_COLUMNS

5.7 ALL_WM_IND_EXPRESSIONS

5.8 ALL_WM_LOCKED_TABLES

5.9 ALL_WM_MODIFIED_TABLES

5.10 ALL_WM_RIC_INFO

5.11 ALL_WM_TAB_TRIGGERS

5.12 ALL_WM_VERSIONED_TABLES

5.13 ALL_WM_VT_ERRORS

5.14 ALL_WORKSPACE_PRIVS

5.15 ALL_WORKSPACE_SAVEPOINTS

5.16 ALL_WORKSPACES

5.17 DBA_WM_SYS_PRIVS

5.18 DBA_WM_VT_ERRORS

5.19 DBA_WORKSPACE_SESSIONS

5.20 ROLE_WM_PRIVS

5.21 USER_MP_GRAPH_WORKSPACES

5.22 USER_MP_PARENT_WORKSPACES

5.23 USER_WM_CONS_COLUMNS

5.24 USER_WM_CONSTRAINTS

5.25 USER_WM_IND_COLUMNS

5.26 USER_WM_IND_EXPRESSIONS

5.27 USER_WM_LOCKED_TABLES

5.28 USER_WM_MODIFIED_TABLES

5.29 USER_WM_PRIVS

5.30 USER_WM_RIC_INFO

5.31 USER_WM_TAB_TRIGGERS

5.32 USER_WM_VERSIONED_TABLES

5.33 USER_WM_VT_ERRORS

5.34 USER_WORKSPACE_PRIVS

5.35 USER_WORKSPACE_SAVEPOINTS

5.36 USER_WORKSPACES

5.37 WM_COMPRESS_BATCH_SIZES

5.38 WM_COMPRESSIBLE_TABLES

5.39 WM_EVENTS_INFO

5.40 WM_INSTALLATION

5.41 WM_REPLICATION_INFO

5.42 xxx_CONF Views

5.43 xxx_DIFF Views

5.44 xxx_HIST Views

5.45 xxx_LOCK Views

5.46 xxx_MW Views

Part III Supplementary Information

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

B.3 History Management Changes for Release 10.1

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 Workspace Manager Error Messages

Glossary

Index