Index

Symbols  A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  R  S  T  U  V  W  

---

Symbols

• _LT tables
  • created for Workspace Manager infrastructure 1.1.11
  • getting name of 4.34

---

A

• Add_Topo_Geometry_Layer procedure 4.1
• AddAsParentWorkspace procedure 4.2
• AddUserDefinedHint procedure 4.3
• Advanced Queuing
  • and Workspace Manager events 2
• ALL_MP_GRAPH_WORKSPACES view 5.1
• ALL_MP_PARENT_WORKSPACES view 5.2
• ALL_REMOVED_WORKSPACES view 5.3
• ALL_VERSION_HVIEW view 5.4
• ALL_WM_CONS_COLUMNS view 5.5
• ALL_WM_CONSTRAINTS view 5.6
• ALL_WM_IND_COLUMNS view 5.7
• ALL_WM_IND_EXPRESSIONS view 5.8
• ALL_WM_LOCKED_TABLES view 5.9
• ALL_WM_MODIFIED_TABLES view 5.10
• ALL_WM_POLICIES view 5.11
• ALL_WM_RIC_INFO view 5.12
• ALL_WM_TAB_TRIGGERS view 5.13
• ALL_WM_VERSIONED_TABLES view 5.14
• ALL_WM_VT_ERRORS view 5.15
• ALL_WORKSPACE_PRIVS view 5.16
• ALL_WORKSPACE_SAVEPOINTS view 5.17
• ALL_WORKSPACES view 5.18
• ALLOW_CAPTURE_EVENTS system parameter 2.3
• altering
  • savepoint description 4.4
  • version-enabled table to add valid time support 4.5
  • workspace description 4.6
• AlterSavepoint procedure 4.4
• AlterVersionedTable procedure 4.5
• AlterWorkspace procedure 4.6
• asynchronous notification for Workspace Manager events 2.4.5
• auditing modifications
  • EnableVersioning history option 4.22
  • history views (xxx_HIST) 5.52
• auto_commit parameter 1.1.8
• autocommitting of operations 1.1.8

---

B

• base row 1.1.4
• BeginBulkLoading procedure 4.7
• BeginDDL procedure 4.8
• BeginResolve procedure 4.9
• bulk loading 1.7
  • BeginBulkLoading procedure 4.7
  • CommitBulkLoading procedure 4.11
  • RollbackBulkLoading procedure 4.75

---

C

• ChangeWorkspaceType procedure 4.10
• child row 1.1.4
• child workspace 1.1.1
  • as alternative to creating savepoint 1.1.2.1
  • merging 4.56
  • refreshing 4.62, 4.63
  • removing 4.68
• CommitBulkLoading procedure 4.11
• CommitDDL procedure 4.12
• CommitResolve procedure 4.13
• compressing
  • workspaces 4.14, 4.15
• compression (Workspace Manager)
  • SetCompressWorkspace procedure 4.82
  • WM_COMPRESS_BATCH_SIZES view 5.46
  • WM_COMPRESSIBLE_TABLES view 5.47
• CompressWorkspace procedure 4.14
• CompressWorkspaceTree procedure 4.15
• conflict management 1.16.6, 4.71
  • beginning resolution 4.9
  • committing resolution 4.13
  • rolling back resolution 4.77
  • showing conflicts 4.83
• conflict resolution
  • example 5.50
• conflict views (xxx_CONF) 5.50
• constraints
  • maximum name length for Workspace Manager 1.1.11
  • support with Workspace Manager 1.9
• context (session) 1.2
  • GetSessionInfo function 4.36
• context of current operation
  • getting 4.32
• continually refreshed workspaces 1.1.9
  • changing workspace type 4.10
  • creating 4.18
• CopyForUpdate procedure 4.16
• CreateSavepoint procedure 4.17
• CreateWorkspace procedure 4.18
• creating
  • savepoints 4.17
  • workspaces 4.18

---

D

• DBA_REMOVED_WORKSPACES view 5.19
• DBA_WM_SYS_PRIVS view 5.20
• DBA_WM_VERSIONED_TABLES view 5.21
• DBA_WM_VT_ERRORS view 5.22
• DBA_WORKSPACE_PRIVS view 5.23
• DBA_WORKSPACE_SAVEPOINTS view 5.24
• DBA_WORKSPACE_SESSIONS view 5.25
• DBA_WORKSPACES view 5.26
• DBMS_WM package 1.1.13
  • Add_Topo_Geometry_Layer 4.1
  • AddAsParentWorkspace 4.2
  • AddUserDefinedHint 4.3
  • AlterSavepoint 4.4
  • AlterVersionedTable 4.5
  • AlterWorkspace 4.6
  • BeginBulkLoading 4.7
  • BeginDDL 4.8
  • BeginResolve 4.9
  • ChangeWorkspaceType 4.10
  • CommitBulkLoading 4.11
  • CommitDDL 4.12
  • CommitResolve 4.13
  • CompressWorkspace 4.14
  • CompressWorkspaceTree 4.15
  • CopyForUpdate 4.16
  • CreateSavepoint 4.17
  • CreateWorkspace 4.18
  • Delete_Topo_Geometry_Layer 4.19
  • DeleteSavepoint 4.20
  • DisableVersioning 4.21
  • EnableVersioning 4.22
  • Export 4.23
  • Export_Schemas 4.24
  • FindRICSet 4.25
  • FreezeWorkspace 4.26
  • GetBulkLoadVersion 4.27
  • GetConflictWorkspace 4.28
  • GetDiffVersions 4.29
  • GetLockMode 4.30
  • GetMultiWorkspaces 4.31
  • GetOpContext 4.32
  • GetOriginalDDL 4.33
  • GetPhysicalTableName 4.34
  • GetPrivs 4.35
  • GetSessionInfo 4.36
  • GetSystemParameter 4.37
  • GetValidFrom 4.38
  • GetValidTill 4.39
  • GetVersion 4.40
  • GetWMMetadataSpace 4.41
  • GetWorkspace 4.42
  • GotoDate 4.43
  • GotoSavepoint 4.44
  • GotoWorkspace 4.45
  • GrantGraphPriv 4.46
  • GrantPrivsOnPolicy 4.47
  • GrantSystemPriv 4.48
  • GrantWorkspacePriv 4.49
  • Import 4.50
  • Import_Schemas 4.51
  • Initialize_After_Import 4.52
  • IsWorkspaceOccupied 4.53
  • LockRows 4.54
  • MergeTable 4.55
  • MergeWorkspace 4.56
  • Move_Proc 4.57
  • PurgeTable 4.58
  • RecoverAllMigratingTables 4.59
  • RecoverFromDroppedUser 4.60
  • RecoverMigratingTable 4.61
  • RefreshTable 4.62
  • RefreshWorkspace 4.63
  • RemoveAsParentWorkspace 4.64
  • RemoveDeferredWorkspaces 4.65
  • RemoveUserDefinedHint 4.66
  • RemoveWorkspace 4.67
  • RemoveWorkspaceTree 4.68
  • RenameSavepoint 4.69
  • RenameWorkspace 4.70
  • ResolveConflicts 4.71
  • RevokeGraphPriv 4.72
  • RevokeSystemPriv 4.73
  • RevokeWorkspacePriv 4.74
  • RollbackBulkLoading 4.75
  • RollbackDDL 4.76
  • RollbackResolve 4.77
  • RollbackTable 4.78
  • RollbackToSP 4.79
  • RollbackWorkspace 4.80
  • SetCaptureEvent 4.81
  • SetCompressWorkspace 4.82
  • SetConflictWorkspace 4.83
  • SetDiffVersions 4.84
  • SetLockingOFF 4.85
  • SetLockingON 4.86
  • SetMultiWorkspaces 4.87
  • SetSystemParameter 4.88
  • SetTriggerEvents 4.89
  • SetValidTime 4.90
  • SetValidTimeFilterOFF 4.91
  • SetValidTimeFilterON 4.92
  • SetWMValidUpdateModeOFF 4.93
  • SetWMValidUpdateModeON 4.94
  • SetWoOverwriteOFF 4.95
  • SetWoOverwriteON 4.96
  • SetWorkspaceLockModeOFF 4.97
  • SetWorkspaceLockModeON 4.98
  • UnfreezeWorkspace 4.99
  • UnlockRows 4.100
  • UseDefaultValuesForNulls 4.101
• DDL (data definition language) operations
  • requirements and restrictions 1.8
• Delete_Topo_Geometry_Layer procedure 4.19
• DeleteSavepoint procedure 4.20
• deleting
  • deferred workspace 4.65
  • savepoints 4.20
  • workspace 1.1.6, 4.67
• difference views (xxx_DIFF) 5.51
• DisableVersioning procedure 4.21
• disabling
  • workspace changes 4.26

---

E

• effective dating
  • See: valid time support
• EnableVersioning procedure 4.22
• event parameters 2.2
• events (Workspace Manager) 2
  • ALLOW_CAPTURE_EVENTS system parameter 2.3
  • asynchronous notification 2.4.5
  • capturing 4.81
  • event parameters 2.2
  • listening for 2.4.4
  • list of events 2.1
  • WM_EVENTS_INFO view 5.48
• example
  • conflict resolution 5.50
  • using Workspace Manager (Oracle sample schemas) 1.17.2
• exclusive locks 1.3, 4.86
• explicit savepoints 1.1.2
• Export_Schemas procedure 4.24
• export considerations 1.6
• Export procedure 4.23

---

F

• FindRICSet procedure 4.25
• foreign keys with version-enabled tables 1.9.1
• FreezeWorkspace procedure 4.26
• freezing
  • workspace changes 1.1.5, 4.26

---

G

• GetBulkLoadVersion function 4.27
• GetConflictWorkspace function 4.28
• GetDiffVersions function 4.29
• GetLockMode function 4.30
• GetMultiWorkspaces function 4.31
• GetOpContext function 4.32
• GetOriginalDDL procedure 4.33
• GetPhysicalTableName function 4.34
• GetPrivs function 4.35
• GetSessionInfo procedure 4.36
• GetSystemParameter function 4.37
• GetValidFrom function 4.38
• GetValidTill function 4.39
• GetVersion function 4.40
• GetWMMetadataSpace function 4.41
• GetWorkspace function 4.42
• GotoDate procedure 4.43
• GotoSavepoint procedure 4.44
• GotoWorkspace procedure 4.45
• GrantGraphPriv procedure 4.46
• granting
  • Workspace Manager privileges
    • multiparent graph workspaces 4.46
    • OLS-related 4.47
    • system 4.48
    • workspace 4.49
• grant option 1.4
• GrantPrivsOnPolicy procedure 4.47
• GrantSystemPriv procedure 4.48
• GrantWorkspacePriv procedure 4.49

---

H

• hierarchy
  • removing 4.68
  • workspaces 1.1.1
• historical data 1.1.12
• history option
  • EnableVersioning procedure 4.22
• history views (xxx_HIST) 5.52

---

I

• implicit savepoints 1.1.2
• Import_Schemas procedure 4.51
• import considerations 1.6
• Import procedure 4.50
• infrastructure for version-enabling of tables 1.1.11
• Initialize_After_Import procedure 4.52
• invisible index
  • supported on version-enabled table 1.8
• IsWorkspaceOccupied function 4.53

---

J

• join index
  • cannot be created or dropped on version-enabled table 1.8

---

L

• LATEST savepoint 1.1.2
• length of object names
  • maximums for Workspace Manager 1.1.11
• LOB columns with versioned tables 4.16
• locking table rows 4.54
• lock management 1.3, 1.16.5
  • with DML operations on tables with referential integrity constraints 1.9.1.1
• lock mode
  • getting 4.30
• LockRows procedure 4.54
• locks
  • disabling 4.85
  • enabling 4.86
  • exclusive 1.3
  • shared 1.3
  • version-exclusive 1.3
  • workspace-exclusive 1.3
• lock views (xxx_LOCK) 5.53
• logging of modifications
  • EnableVersioning history option 4.22
  • history views (xxx_HIST) 5.52
• long transactions 1
• LT tables
  • created for Workspace Manager infrastructure 1.1.11
  • getting name of _LT (physical) table 4.34

---

M

• materialized views
  • version management with 1.13
• MergeTable procedure 4.55
• MergeWorkspace procedure 4.56
• merging
  • table changes 4.55
  • workspaces 1.1.3, 4.56
• metadata space
  • getting 4.41
• Move_Proc procedure 4.57
• multilevel referential integrity constraints 1.9.1
• multiparent workspaces 1.1.10
• multiworkspace views (xxx_MW) 5.54

---

N

• name length of database objects
  • maximums for Workspace Manager 1.1.11
• nonsequenced update operations 3.6.2.1
• null values
  • using default values for 4.101

---

O

• OE.WAREHOUSES table
  • Workspace Manager example 1.17.2
• OLS (Oracle Label Security)
  • DDL operations on version-enabled tables 1.8
  • granting privileges related to 4.47
• operation context
  • getting 4.32
• operators for valid time support 3.5
  • WM_CONTAINS 3.5.1
  • WM_EQUALS 3.5.2
  • WM_GREATERTHAN 3.5.3
  • WM_INTERSECTION 3.5.4
  • WM_LDIFF 3.5.5
  • WM_LESSTHAN 3.5.6
  • WM_MEETS 3.5.7
  • WM_OVERLAPS 3.5.8
  • WM_RDIFF 3.5.9
• Oracle Label Security (OLS)
  • DDL operations on version-enabled tables 1.8
  • granting privileges related to 4.47
• Oracle sample schemas
  • Workspace Manager example 1.17.2
• OWM_VERSION
  • Workspace Manager version number 5.49

---

P

• parent row 1.1.4
• parent workspace 1.1.1
  • conflicts with 4.83
• partitioned index
  • cannot be created or dropped on version-enabled table 1.8
• physical table name
  • and Workspace Manager infrastructure 1.1.11
  • getting 4.34
• privilege management 1.16.4
• privileges
  • description 1.4
  • getting 4.35
  • granted to PUBLIC user group 1.1.13
  • granting 4.48, 4.49
    • multiparent graph workspaces 4.46
    • OLS-related 4.47
  • grant option 1.4
  • managing 1.4
  • revoking 1.4, 4.73, 4.74
    • multiparent graph workspaces 4.72
  • viewing users having Workspace Manager system-level privileges 5.20
• PurgeTable procedure 4.58

---

R

• RecoverAllMigratingTables procedure 4.59
• RecoverFromDroppedUser procedure 4.60
• RecoverMigratingTable procedure 4.61
• referential integrity constraints
  • finding affected tables 4.25
  • lock management with DML operations 1.9.1.1
• referential integrity support 1.9.1
  • multilevel constraints 1.9.1
• refreshing
  • tables 4.62
  • workspaces 4.63
• RefreshTable procedure 4.62
• RefreshWorkspace procedure 4.63
• removable savepoints 1.1.2
• RemoveAsParentWorkspace procedure 4.64
• RemoveDeferredWorkspaces procedure 4.65
• RemoveUserDefinedHint procedure 4.66
• RemoveWorkspace procedure 4.67
• RemoveWorkspaceTree procedure 4.68
• removing deferred workspaces 4.65
• removing workspaces 1.1.6, 4.67
• RenameSavepoint procedure 4.69
• RenameWorkspace procedure 4.70
• renaming
  • savepoint 4.69
  • workspace 4.70
• reserved words and characters with Workspace Manager 1.15
• ResolveConflicts procedure 4.71
• resolving conflicts 4.71
  • beginning 4.9
  • committing 4.13
  • rolling back 4.77
• RETURNING clause
  • not supported for INSERT or UPDATE on version-enabled tables 1.1.11
• reverse index
  • supported on version-enabled table 1.8
• RevokeGraphPriv procedure 4.72
• RevokeSystemPriv procedure 4.73
• RevokeWorkspacePriv procedure 4.74
• revoking privileges 1.4, 4.73, 4.74
  • multiparent graph workspaces 4.72
• ROLE_WM_PRIVS view 5.27
• RollbackBulkLoading procedure 4.75
• RollbackDDL procedure 4.76
• RollbackResolve procedure 4.77
• RollbackTable procedure 4.78
• RollbackToSP procedure 4.79
• RollbackWorkspace procedure 4.80
• rolling back
  • changes in a table 4.78
  • workspace changes 1.1.3, 4.80
  • workspaces to savepoint 4.79
• row-level security (VPD)
  • Workspace Manager considerations 1.11
• rows
  • locking 4.54
  • unlocking 4.100
• row versions
  • creation of 1.1.12
• rule-based subscription for Workspace Manager events 2.4.3

---

S

• sample schemas
  • Workspace Manager example 1.17.2
• savepoint management 1.16.3
• savepoints 1.1
  • altering description of 4.4
  • as alternative to creating child workspaces 1.1.2.1
  • creating 4.17
  • deleting 4.20
  • explicit 1.1.2
  • going to 4.44
  • implicit 1.1.2
  • removable 1.1.2
  • renaming 4.69
  • rolling back to 4.79
• sequenced delete operations 3.6.2.1
  • disabling 4.93
  • enabling 4.94
• sequenced update operations 3.6.2.1
  • disabling 4.93
  • enabling 4.94
• session context 1.2
  • GetSessionInfo function 4.36
• SetCaptureEvent procedure 4.81
• SetCompressWorkspace procedure 4.82
• SetConflictWorkspace procedure 4.83
• SetDiffVersions procedure 4.84
• SetLockingOFF procedure 4.85
• SetLockingON procedure 4.86
• SetMultiWorkspaces procedure 4.87
• SET NULL constraints
  • not supported for version-enabled tables 1.9.3
• SetSystemParameter procedure 4.88
• SetTriggerEvents procedure 4.89
• SetValidTimeFilterOFF procedure 4.91
• SetValidTimeFilterON procedure 4.92
• SetValidTime procedure 4.90
• SetWMValidUpdateModeOFF procedure 4.93
• SetWMValidUpdateModeON procedure 4.94
• SetWoOverwriteOFF procedure 4.95
• SetWoOverwriteON procedure 4.96
• SetWorkspaceLockModeOFF procedure 4.97
• SetWorkspaceLockModeON procedure 4.98
• shared locks 1.3, 4.86
• skeleton tables 1.8
• spatial topologies
  • version management with 1.14
• subscription (rule-based) for Workspace Manager events 2.4.3
• synonyms
  • support for 1.12
• system parameters
  • for Workspace Manager 1.5
  • shown in WM_INSTALLATION view 5.49
• system privileges 4.48
  • viewing users having Workspace Manager system-level privileges 5.20

---

T

• table management 1.16.1
• table name
  • and Workspace Manager infrastructure 1.1.11
  • getting physical table name 4.34
  • maximum length for Workspace Manager 1.1.11
• table synonyms 1.12
• topologies
  • version management with 1.14
• topology geometry layer
  • adding 4.1
  • deleting 4.19
• trigger events
  • setting 4.89
• triggers on version-enabled tables 1.10

---

U

• UnfreezeWorkspace procedure 4.99
• unfreezing
  • workspaces 1.1.5, 4.99
• unique constraints
  • support with Workspace Manager 1.9.2
• unlocking
  • table rows 4.100
• UnlockRows procedure 4.100
• UseDefaultValuesForNulls procedure 4.101
• USER_MP_GRAPH_WORKSPACES view 5.28
• USER_MP_PARENT_WORKSPACES view 5.29
• USER_REMOVED_WORKSPACES view 5.30
• USER_WM_CONS_COLUMNS view 5.31
• USER_WM_CONSTRAINTS view 5.32
• USER_WM_IND_COLUMNS view 5.33
• USER_WM_IND_EXPRESSIONS view 5.34
• USER_WM_LOCKED_TABLES view 5.35
• USER_WM_MODIFIED_TABLES view 5.36
• USER_WM_POLICIES view 5.37
• USER_WM_PRIVS view 5.38
• USER_WM_RIC_INFO view 5.39
• USER_WM_TAB_TRIGGERS view 5.40
• USER_WM_VERSIONED_TABLES view 5.41
• USER_WM_VT_ERRORS view 5.42
• USER_WORKSPACE_PRIVS view 5.43
• USER_WORKSPACE_SAVEPOINTS view 5.44
• USER_WORKSPACES view 5.45
• user-defined hints
  • adding 4.3
  • removing 4.66

---

V

• valid time filter
  • removing 4.91
  • setting 4.92
• valid time support 3
  • altering version-enabled table to add valid time support 4.5
  • operators 3.5
  • setting valid time for session 4.90
• version-enabled tables
  • definition 1.1
  • maximum name length for Workspace Manager 1.1.11
• version-exclusive locks 1.3
• versioning
  • disabling 4.21
  • enabling 4.22
  • infrastructure created for 1.1.11
• version number
  • Workspace Manager (OWM_VERSION) 5.49
• VIEW_WO_OVERWRITE mode
  • disabling 4.95
  • enabling 4.96
• virtual private databases
  • with Workspace Manager 1.11
• VPD (virtual private database)
  • with Workspace Manager 1.11

---

W

• WM_ADMIN_ROLE role 1.4
• WM_COMPRESS_BATCH_SIZES view 5.46
• WM_COMPRESSIBLE_TABLES view 5.47
• WM_CONTAINS operator 3.5.1
• WM_EQUALS operator 3.5.2
• WM_EVENTS_INFO view 5.48
• WM_GREATERTHAN operator 3.5.3
• WM_INSTALLATION view 5.49
• WM_INTERSECTION operator 3.5.4
• WM_LDIFF operator 3.5.5
• WM_LESSTHAN operator 3.5.6
• WM_MEETS operator 3.5.7
• WM_OVERLAPS operator 3.5.8
• WM_RDIFF operator 3.5.9
• WMSYS schema and user 1.1.13
• workspace-exclusive locks 1.3
• workspace lock mode
  • disabling 4.97
  • enabling 4.98
• Workspace Manager metadata space
  • getting 4.41
• Workspace Manager version
  • getting 4.40
• workspaces
  • altering description of 4.6
  • changing type 4.10
  • child
    • as alternative to creating savepoints 1.1.2.1
  • compressing 4.14, 4.15
  • continually refreshed 1.1.9, 4.10, 4.18
  • creating 4.18
  • freezing 1.1.5, 4.26
  • getting 4.42
  • going to 4.45
  • hierarchy 1.1.1
  • management of 1.1, 1.16.2
  • merging 1.1.3
  • multiparent 1.1.10
  • renaming 4.70
  • rolling back 1.1.3
  • unfreezing 1.1.5, 4.99