Skip Headers
Oracle® Database Application Developer's Guide - Workspace Manager
10g Release 2 (10.2)

Part Number B14253-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to next page
Next
View PDF

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Audience
Documentation Accessibility
Organization
Related Documentation
Conventions

What's New in Workspace Manager?

where_clause Parameter and Subqueries
New Valid Time Procedures
MP_ROOT_WORKSPACE Column in xxx_WORKSPACES Views
DBA_WM_VT_ERRORS View
auto_commit Parameter Added to SetWorkspaceLockModeOn and SetWorkspaceLockModeOff Procedures
Parameters Removed for SetValidTime Procedure
Dropping Users with Version-Enabled Tables
DDL Operations and Table-Level Privileges

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 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.2 Unique 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 Metadata 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
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
GrantSystemPriv
GrantWorkspacePriv
Import
IsWorkspaceOccupied
LockRows
MergeTable
MergeWorkspace
Move_Proc
RecoverAllMigratingTables
RecoverFromDroppedUser
RecoverMigratingTable
RefreshTable
RefreshWorkspace
RelocateWriterSite
RemoveAsParentWorkspace
RemoveWorkspace
RemoveWorkspaceTree
ResolveConflicts
RevokeGraphPriv
RevokeSystemPriv
RevokeWorkspacePriv
RollbackBulkLoading
RollbackDDL
RollbackResolve
RollbackTable
RollbackToSP
RollbackWorkspace
SetCaptureEvent
SetCompressWorkspace
SetConflictWorkspace
SetDiffVersions
SetLockingOFF
SetLockingON
SetMultiWorkspaces
SetSystemParameter
SetTriggerEvents
SetValidTime
SetWMValidTimeFilterOFF
SetWMValidTimeFilterON
SetWMValidUpdateModeOFF
SetWMValidUpdateModeON
SetWoOverwriteOFF
SetWoOverwriteON
SetWorkspaceLockModeOFF
SetWorkspaceLockModeON
SynchronizeSite
UnfreezeWorkspace
UnlockRows
UseDefaultValuesForNulls

5 Workspace Manager Metadata Views

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

Part III Supplementary Information

A Installing Workspace Manager with Custom Databases

B Migrating to Another Workspace Manager Release

B.1 Upgrading to the Current Release
B.2 Downgrading to a Previous Release
B.3 History Management Changes for 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