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

New and Changed Features

System Parameters for Workspace Manager

Multiparent Workspaces

Workspace Manager Events

Valid Time Support

Exporting and Importing Data

Bulk Loading into Version-Enabled Tables

Compression, Commit Operations, and Batch Sizes

Continually Refreshed Workspaces: New Procedure

Physical Table Names (Infrastructure): New Procedure

DDL Support

Unique Constraint Support

Nested Table Column Support

Virtual Private Database (VPD) Support

Spatial Topology Support

History Management Support

New Lock Modes: Workspace-Exclusive and Version-Exclusive

New Parameter for Compressing Workspaces

Renaming a Constraint or Index

New Parameter for RefreshWorkspace

Workspace Manager Metadata Placement

Using Default Values for Nulls

DBA_WM_SYS_PRIVS View

Column Name Changes in xxx_HIST Views

Sample Schema Example

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.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 DBMS_WM Subprogram Categories

1.15.1 Table Management Subprograms

1.15.2 Workspace Management Subprograms

1.15.3 Savepoint Management Subprograms

1.15.4 Privilege Management Subprograms

1.15.5 Lock Management Subprograms

1.15.6 Conflict Management Subprograms

1.15.7 Replication Support Subprograms

1.15.8 Bulk Load Support Subprograms

1.16 Simplified Examples Using Workspace Manager

1.16.1 Example: Marketing Budget Options

1.16.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

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

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_WORKSPACE_SESSIONS

5.19 ROLE_WM_PRIVS

5.20 USER_MP_GRAPH_WORKSPACES

5.21 USER_MP_PARENT_WORKSPACES

5.22 USER_WM_CONS_COLUMNS

5.23 USER_WM_CONSTRAINTS

5.24 USER_WM_IND_COLUMNS

5.25 USER_WM_IND_EXPRESSIONS

5.26 USER_WM_LOCKED_TABLES

5.27 USER_WM_MODIFIED_TABLES

5.28 USER_WM_PRIVS

5.29 USER_WM_RIC_INFO

5.30 USER_WM_TAB_TRIGGERS

5.31 USER_WM_VERSIONED_TABLES

5.32 USER_WM_VT_ERRORS

5.33 USER_WORKSPACE_PRIVS

5.34 USER_WORKSPACE_SAVEPOINTS

5.35 USER_WORKSPACES

5.36 WM_COMPRESS_BATCH_SIZES

5.37 WM_COMPRESSIBLE_TABLES

5.38 WM_EVENTS_INFO

5.39 WM_INSTALLATION

5.40 WM_REPLICATION_INFO

5.41 xxx_CONF Views

5.42 xxx_DIFF Views

5.43 xxx_HIST Views

5.44 xxx_LOCK Views

5.45 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