Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Workspace Manager Developer's Guide
- 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.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.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.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.15 Workspace Manager Reserved Words and Characters
- 1.16 DBMS_WM Subprogram Categories
- 1.17 Simplified Examples Using Workspace Manager
- 1.1
Workspace Manager Overview
- 2 Workspace Manager Events
- 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.6 Queries and DML Operations with Valid Time Support
- 3.7 Constraint Management for Valid Time Support
- 3.8 Locking with Valid Time Support
- 3.9 Static Data Dictionary Views Affected by 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
- 1
Introduction to Workspace Manager
- 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
- 4
DBMS_WM Package: Reference
- Part III Supplementary Information
- A Installing Workspace Manager with Custom Databases
- B Workspace Manager Error Messages
- Glossary
- Index