1/18

Contents

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 2 (12.2)
  • New Features (12.2)
    • New DBMS_WM Subprograms (12.2)
    • Changes to Existing DBMS_WM Subprograms (12.2)
    • Other Enhancements (12.2)
    • Workspace Manager Static Data Dictionary Views (12.2)
    • System Parameter-Related Changes (12.2)
    • Privilege-Related Changes (12.2)
  • Desupported: Advanced Replication Support in Workspace Manager (12.2)

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

• 4.1 Add_Topo_Geometry_Layer
• 4.2 AddAsParentWorkspace
• 4.3 AddUserDefinedHint
• 4.4 AlterSavepoint
• 4.5 AlterVersionedTable
• 4.6 AlterWorkspace
• 4.7 BeginBulkLoading
• 4.8 BeginDDL
• 4.9 BeginResolve
• 4.10 ChangeWorkspaceType
• 4.11 CommitBulkLoading
• 4.12 CommitDDL
• 4.13 CommitResolve
• 4.14 CompressWorkspace
• 4.15 CompressWorkspaceTree
• 4.16 CopyForUpdate
• 4.17 CreateSavepoint
• 4.18 CreateWorkspace
• 4.19 Delete_Topo_Geometry_Layer
• 4.20 DeleteSavepoint
• 4.21 DisableVersioning
• 4.22 EnableVersioning
• 4.23 Export
• 4.24 Export_Schemas
• 4.25 FindRICSet
• 4.26 FreezeWorkspace
• 4.27 GetBulkLoadVersion
• 4.28 GetConflictWorkspace
• 4.29 GetDiffVersions
• 4.30 GetLockMode
• 4.31 GetMultiWorkspaces
• 4.32 GetOpContext
• 4.33 GetOriginalDDL
• 4.34 GetPhysicalTableName
• 4.35 GetPrivs
• 4.36 GetSessionInfo
• 4.37 GetSystemParameter
• 4.38 GetValidFrom
• 4.39 GetValidTill
• 4.40 GetVersion
• 4.41 GetWMMetadataSpace
• 4.42 GetWorkspace
• 4.43 GotoDate
• 4.44 GotoSavepoint
• 4.45 GotoWorkspace
• 4.46 GrantGraphPriv
• 4.47 GrantPrivsOnPolicy
• 4.48 GrantSystemPriv
• 4.49 GrantWorkspacePriv
• 4.50 Import
• 4.51 Import_Schemas
• 4.52 Initialize_After_Import
• 4.53 IsWorkspaceOccupied
• 4.54 LockRows
• 4.55 MergeTable
• 4.56 MergeWorkspace
• 4.57 Move_Proc
• 4.58 PurgeTable
• 4.59 RecoverAllMigratingTables
• 4.60 RecoverFromDroppedUser
• 4.61 RecoverMigratingTable
• 4.62 RefreshTable
• 4.63 RefreshWorkspace
• 4.64 RemoveAsParentWorkspace
• 4.65 RemoveDeferredWorkspaces
• 4.66 RemoveUserDefinedHint
• 4.67 RemoveWorkspace
• 4.68 RemoveWorkspaceTree
• 4.69 RenameSavepoint
• 4.70 RenameWorkspace
• 4.71 ResolveConflicts
• 4.72 RevokeGraphPriv
• 4.73 RevokeSystemPriv
• 4.74 RevokeWorkspacePriv
• 4.75 RollbackBulkLoading
• 4.76 RollbackDDL
• 4.77 RollbackResolve
• 4.78 RollbackTable
• 4.79 RollbackToSP
• 4.80 RollbackWorkspace
• 4.81 SetCaptureEvent
• 4.82 SetCompressWorkspace
• 4.83 SetConflictWorkspace
• 4.84 SetDiffVersions
• 4.85 SetLockingOFF
• 4.86 SetLockingON
• 4.87 SetMultiWorkspaces
• 4.88 SetSystemParameter
• 4.89 SetTriggerEvents
• 4.90 SetValidTime
• 4.91 SetValidTimeFilterOFF
• 4.92 SetValidTimeFilterON
• 4.93 SetWMValidUpdateModeOFF
• 4.94 SetWMValidUpdateModeON
• 4.95 SetWoOverwriteOFF
• 4.96 SetWoOverwriteON
• 4.97 SetWorkspaceLockModeOFF
• 4.98 SetWorkspaceLockModeON
• 4.99 UnfreezeWorkspace
• 4.100 UnlockRows
• 4.101 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 xxx_CONF Views
• 5.51 xxx_DIFF Views
• 5.52 xxx_HIST Views
• 5.53 xxx_LOCK Views
• 5.54 xxx_MW Views

Part III Supplementary Information

A Installing Workspace Manager with Custom Databases

B Workspace Manager Error Messages

Glossary

Index