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 CopyWorkspace
- 4.18 CreateSavepoint
- 4.19 CreateWorkspace
- 4.20 Delete_Topo_Geometry_Layer
- 4.21 DeleteSavepoint
- 4.22 DisableVersioning
- 4.23 EnableVersioning
- 4.24 Export
- 4.25 Export_Schemas
- 4.26 FindRICSet
- 4.27 FreezeWorkspace
- 4.28 GetBulkLoadVersion
- 4.29 GetConflictWorkspace
- 4.30 GetDiffVersions
- 4.31 GetLockMode
- 4.32 GetMultiWorkspaces
- 4.33 GetOpContext
- 4.34 GetOriginalDDL
- 4.35 GetPhysicalTableName
- 4.36 GetPrivs
- 4.37 GetSessionInfo
- 4.38 GetSystemParameter
- 4.39 GetValidFrom
- 4.40 GetValidTill
- 4.41 GetVersion
- 4.42 GetWMMetadataSpace
- 4.43 GetWorkspace
- 4.44 GotoDate
- 4.45 GotoSavepoint
- 4.46 GotoWorkspace
- 4.47 GrantGraphPriv
- 4.48 GrantPrivsOnPolicy
- 4.49 GrantSystemPriv
- 4.50 GrantWorkspacePriv
- 4.51 Import
- 4.52 Import_Schemas
- 4.53 Initialize_After_Import
- 4.54 IsWorkspaceOccupied
- 4.55 LockRows
- 4.56 MergeTable
- 4.57 MergeWorkspace
- 4.58 Move_Proc
- 4.59 PurgeTable
- 4.60 RecoverAllMigratingTables
- 4.61 RecoverFromDroppedUser
- 4.62 RecoverMigratingTable
- 4.63 RefreshTable
- 4.64 RefreshWorkspace
- 4.65 RemoveAsParentWorkspace
- 4.66 RemoveDeferredWorkspaces
- 4.67 RemoveUserDefinedHint
- 4.68 RemoveWorkspace
- 4.69 RemoveWorkspaceTree
- 4.70 RenameSavepoint
- 4.71 RenameWorkspace
- 4.72 ResolveConflicts
- 4.73 RevokeGraphPriv
- 4.74 RevokeSystemPriv
- 4.75 RevokeWorkspacePriv
- 4.76 RollbackBulkLoading
- 4.77 RollbackDDL
- 4.78 RollbackResolve
- 4.79 RollbackTable
- 4.80 RollbackToSP
- 4.81 RollbackWorkspace
- 4.82 SetCaptureEvent
- 4.83 SetCompressWorkspace
- 4.84 SetConflictWorkspace
- 4.85 SetDiffVersions
- 4.86 SetLockingOFF
- 4.87 SetLockingON
- 4.88 SetMultiWorkspaces
- 4.89 SetSystemParameter
- 4.90 SetTriggerEvents
- 4.91 SetValidTime
- 4.92 SetValidTimeFilterOFF
- 4.93 SetValidTimeFilterON
- 4.94 SetWMValidUpdateModeOFF
- 4.95 SetWMValidUpdateModeON
- 4.96 SetWoOverwriteOFF
- 4.97 SetWoOverwriteON
- 4.98 SetWorkspaceLockModeOFF
- 4.99 SetWorkspaceLockModeON
- 4.100 UnfreezeWorkspace
- 4.101 UnlockRows
- 4.102 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_CONSTRAINT_VIOLATIONS
- 5.7 ALL_WM_CONSTRAINTS
- 5.8 ALL_WM_IND_COLUMNS
- 5.9 ALL_WM_IND_EXPRESSIONS
- 5.10 ALL_WM_LOCKED_TABLES
- 5.11 ALL_WM_MODIFIED_TABLES
- 5.12 ALL_WM_POLICIES
- 5.13 ALL_WM_RIC_INFO
- 5.14 ALL_WM_TAB_TRIGGERS
- 5.15 ALL_WM_VERSIONED_TABLES
- 5.16 ALL_WM_VT_ERRORS
- 5.17 ALL_WORKSPACE_PRIVS
- 5.18 ALL_WORKSPACE_SAVEPOINTS
- 5.19 ALL_WORKSPACES
- 5.20 DBA_REMOVED_WORKSPACES
- 5.21 DBA_WM_SYS_PRIVS
- 5.22 DBA_WM_VERSIONED_TABLES
- 5.23 DBA_WM_VT_ERRORS
- 5.24 DBA_WORKSPACE_PRIVS
- 5.25 DBA_WORKSPACE_SAVEPOINTS
- 5.26 DBA_WORKSPACE_SESSIONS
- 5.27 DBA_WORKSPACES
- 5.28 ROLE_WM_PRIVS
- 5.29 USER_MP_GRAPH_WORKSPACES
- 5.30 USER_MP_PARENT_WORKSPACES
- 5.31 USER_REMOVED_WORKSPACES
- 5.32 USER_WM_CONS_COLUMNS
- 5.33 USER_WM_CONSTRAINTS
- 5.34 USER_WM_IND_COLUMNS
- 5.35 USER_WM_IND_EXPRESSIONS
- 5.36 USER_WM_LOCKED_TABLES
- 5.37 USER_WM_MODIFIED_TABLES
- 5.38 USER_WM_POLICIES
- 5.39 USER_WM_PRIVS
- 5.40 USER_WM_RIC_INFO
- 5.41 USER_WM_TAB_TRIGGERS
- 5.42 USER_WM_VERSIONED_TABLES
- 5.43 USER_WM_VT_ERRORS
- 5.44 USER_WORKSPACE_PRIVS
- 5.45 USER_WORKSPACE_SAVEPOINTS
- 5.46 USER_WORKSPACES
- 5.47 WM_COMPRESS_BATCH_SIZES
- 5.48 WM_COMPRESSIBLE_TABLES
- 5.49 WM_EVENTS_INFO
- 5.50 WM_INSTALLATION
- 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
-
4
DBMS_WM Package: Reference
- Part III Supplementary Information
- A Installing Workspace Manager with Custom Databases
- B Workspace Manager Error Messages
- Glossary
- Index