Skip Headers
Oracle® Database Workspace Manager Developer's Guide
11g Release 1 (11.1)
Part Number B28396-02
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's New in Workspace Manager?
New Workspace Manager System Parameters
New Options for the AlterVersionedTable Procedure
New Parameter for the EnableVersioning Procedure
New Views for Removed Workspaces
Merging Multiple Tables
Workspace ID Column Added to Static Data Dictionary Views
User-Defined Hints
Adding, Merging, or Splitting Table Partitions
Null Foreign Key Constraints
Oracle Label Security Policies and Version-Enabled Tables
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.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 Topology Support
1.14.1
Locking Considerations with Topologies
1.14.2
Additional Considerations with Topologies
1.15
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
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
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
FindRICSet
FreezeWorkspace
GenerateReplicationSupport
GetBulkLoadVersion
GetConflictWorkspace
GetDiffVersions
GetLockMode
GetMultiWorkspaces
GetOpContext
GetPhysicalTableName
GetPrivs
GetSessionInfo
GetSystemParameter
GetValidFrom
GetValidTill
GetWMMetadataSpace
GetWorkspace
GotoDate
GotoSavepoint
GotoWorkspace
GrantGraphPriv
GrantPrivsOnPolicy
GrantSystemPriv
GrantWorkspacePriv
Import
IsWorkspaceOccupied
LockRows
MergeTable
MergeWorkspace
Move_Proc
RecoverAllMigratingTables
RecoverFromDroppedUser
RecoverMigratingTable
RefreshTable
RefreshWorkspace
RelocateWriterSite
RemoveAsParentWorkspace
RemoveUserDefinedHint
RemoveWorkspace
RemoveWorkspaceTree
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_RIC_INFO
5.12
ALL_WM_TAB_TRIGGERS
5.13
ALL_WM_VERSIONED_TABLES
5.14
ALL_WM_VT_ERRORS
5.15
ALL_WORKSPACE_PRIVS
5.16
ALL_WORKSPACE_SAVEPOINTS
5.17
ALL_WORKSPACES
5.18
DBA_WM_SYS_PRIVS
5.19
DBA_WM_VT_ERRORS
5.20
DBA_WORKSPACE_SESSIONS
5.21
DBA_WORKSPACES
5.22
ROLE_WM_PRIVS
5.23
USER_MP_GRAPH_WORKSPACES
5.24
USER_MP_PARENT_WORKSPACES
5.25
USER_REMOVED_WORKSPACES
5.26
USER_WM_CONS_COLUMNS
5.27
USER_WM_CONSTRAINTS
5.28
USER_WM_IND_COLUMNS
5.29
USER_WM_IND_EXPRESSIONS
5.30
USER_WM_LOCKED_TABLES
5.31
USER_WM_MODIFIED_TABLES
5.32
USER_WM_PRIVS
5.33
USER_WM_RIC_INFO
5.34
USER_WM_TAB_TRIGGERS
5.35
USER_WM_VERSIONED_TABLES
5.36
USER_WM_VT_ERRORS
5.37
USER_WORKSPACE_PRIVS
5.38
USER_WORKSPACE_SAVEPOINTS
5.39
USER_WORKSPACES
5.40
WM_COMPRESS_BATCH_SIZES
5.41
WM_COMPRESSIBLE_TABLES
5.42
WM_EVENTS_INFO
5.43
WM_INSTALLATION
5.44
WM_REPLICATION_INFO
5.45
xxx_CONF Views
5.46
xxx_DIFF Views
5.47
xxx_HIST Views
5.48
xxx_LOCK Views
5.49
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