1/21

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Database Workspace Manager Developer's Guide

• Changes in Oracle Database 12c Release 1 (12.1)

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 Creation of Row Versions and Historical Copies
  • 1.1.13 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.3.2 Locks Taken for Workspace Manager Operations
• 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.1.1 Locking with DML Operations on Tables with Referential Integrity Constraints
  • 1.9.2 Unique Constraints
  • 1.9.3 SET NULL 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 and Graph Topology Support
  • 1.14.1 Locking Considerations with Topologies
  • 1.14.2 Additional Considerations with Topologies
• 1.15 Workspace Manager 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 Static Data Dictionary 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 Adding Valid Time Support to an Existing Table
• 3.11 Merging and Refreshing Workspaces for Tables with Valid Time Support

Part II Reference Information

4 DBMS_WM Package: Reference

• Add_Topo_Geometry_Layer
• AddAsParentWorkspace
• AddUserDefinedHint
• AlterSavepoint
• AlterVersionedTable
• AlterWorkspace
• BeginBulkLoading
• BeginDDL
• BeginResolve
• ChangeWorkspaceType
• CommitBulkLoading
• CommitDDL
• CommitResolve
• CompressWorkspace
• CompressWorkspaceTree
• CopyForUpdate
• CreateSavepoint
• CreateWorkspace
• Delete_Topo_Geometry_Layer
• DeleteSavepoint
• DisableVersioning
• DropReplicationSupport
• EnableVersioning
• Export
• Export_Schemas
• FindRICSet
• FreezeWorkspace
• GenerateReplicationSupport
• GetBulkLoadVersion
• GetConflictWorkspace
• GetDiffVersions
• GetLockMode
• GetMultiWorkspaces
• GetOpContext
• GetOriginalDDL
• GetPhysicalTableName
• GetPrivs
• GetSessionInfo
• GetSystemParameter
• GetValidFrom
• GetValidTill
• GetWMMetadataSpace
• GetWorkspace
• GotoDate
• GotoSavepoint
• GotoWorkspace
• GrantGraphPriv
• GrantPrivsOnPolicy
• GrantSystemPriv
• GrantWorkspacePriv
• Import
• Import_Schemas
• IsWorkspaceOccupied
• LockRows
• MergeTable
• MergeWorkspace
• Move_Proc
• PurgeTable
• RecoverAllMigratingTables
• RecoverFromDroppedUser
• RecoverMigratingTable
• RefreshTable
• RefreshWorkspace
• RelocateWriterSite
• RemoveAsParentWorkspace
• RemoveUserDefinedHint
• RemoveWorkspace
• RemoveWorkspaceTree
• RenameSavepoint
• RenameWorkspace
• ResolveConflicts
• RevokeGraphPriv
• RevokeSystemPriv
• RevokeWorkspacePriv
• RollbackBulkLoading
• RollbackDDL
• RollbackResolve
• RollbackTable
• RollbackToSP
• RollbackWorkspace
• SetCaptureEvent
• SetCompressWorkspace
• SetConflictWorkspace
• SetDiffVersions
• SetLockingOFF
• SetLockingON
• SetMultiWorkspaces
• SetSystemParameter
• SetTriggerEvents
• SetValidTime
• SetValidTimeFilterOFF
• SetValidTimeFilterON
• SetWMValidUpdateModeOFF
• SetWMValidUpdateModeON
• SetWoOverwriteOFF
• SetWoOverwriteON
• SetWorkspaceLockModeOFF
• SetWorkspaceLockModeON
• SynchronizeSite
• UnfreezeWorkspace
• UnlockRows
• UseDefaultValuesForNulls

5 Workspace Manager Static Data Dictionary Views

• 5.1 ALL_MP_GRAPH_WORKSPACES
• 5.2 ALL_MP_PARENT_WORKSPACES
• 5.3 ALL_REMOVED_WORKSPACES
• 5.4 ALL_VERSION_HVIEW
• 5.5 ALL_WM_CONS_COLUMNS
• 5.6 ALL_WM_CONSTRAINTS
• 5.7 ALL_WM_IND_COLUMNS
• 5.8 ALL_WM_IND_EXPRESSIONS
• 5.9 ALL_WM_LOCKED_TABLES
• 5.10 ALL_WM_MODIFIED_TABLES
• 5.11 ALL_WM_POLICIES
• 5.12 ALL_WM_RIC_INFO
• 5.13 ALL_WM_TAB_TRIGGERS
• 5.14 ALL_WM_VERSIONED_TABLES
• 5.15 ALL_WM_VT_ERRORS
• 5.16 ALL_WORKSPACE_PRIVS
• 5.17 ALL_WORKSPACE_SAVEPOINTS
• 5.18 ALL_WORKSPACES
• 5.19 DBA_REMOVED_WORKSPACES
• 5.20 DBA_WM_SYS_PRIVS
• 5.21 DBA_WM_VERSIONED_TABLES
• 5.22 DBA_WM_VT_ERRORS
• 5.23 DBA_WORKSPACE_PRIVS
• 5.24 DBA_WORKSPACE_SAVEPOINTS
• 5.25 DBA_WORKSPACE_SESSIONS
• 5.26 DBA_WORKSPACES
• 5.27 ROLE_WM_PRIVS
• 5.28 USER_MP_GRAPH_WORKSPACES
• 5.29 USER_MP_PARENT_WORKSPACES
• 5.30 USER_REMOVED_WORKSPACES
• 5.31 USER_WM_CONS_COLUMNS
• 5.32 USER_WM_CONSTRAINTS
• 5.33 USER_WM_IND_COLUMNS
• 5.34 USER_WM_IND_EXPRESSIONS
• 5.35 USER_WM_LOCKED_TABLES
• 5.36 USER_WM_MODIFIED_TABLES
• 5.37 USER_WM_POLICIES
• 5.38 USER_WM_PRIVS
• 5.39 USER_WM_RIC_INFO
• 5.40 USER_WM_TAB_TRIGGERS
• 5.41 USER_WM_VERSIONED_TABLES
• 5.42 USER_WM_VT_ERRORS
• 5.43 USER_WORKSPACE_PRIVS
• 5.44 USER_WORKSPACE_SAVEPOINTS
• 5.45 USER_WORKSPACES
• 5.46 WM_COMPRESS_BATCH_SIZES
• 5.47 WM_COMPRESSIBLE_TABLES
• 5.48 WM_EVENTS_INFO
• 5.49 WM_INSTALLATION
• 5.50 WM_REPLICATION_INFO
• 5.51 xxx_CONF Views
• 5.52 xxx_DIFF Views
• 5.53 xxx_HIST Views
• 5.54 xxx_LOCK Views
• 5.55 xxx_MW Views

Part III Supplementary Information

A Installing Workspace Manager with Custom Databases

B Migrating to Another Workspace Manager Release

• B.1 Upgrading Workspace Manager
• B.2 Downgrading to a Previous Release
• B.3 History Management Changes Effective With 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