1. Index

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.35

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_CONSTRAINT_VIOLATIONS view 5.6
  • ALL_WM_CONSTRAINTS view 5.7
  • ALL_WM_IND_COLUMNS view 5.8
  • ALL_WM_IND_EXPRESSIONS view 5.9
  • ALL_WM_LOCKED_TABLES view 5.10
  • ALL_WM_MODIFIED_TABLES view 5.11
  • ALL_WM_POLICIES view 5.12
  • ALL_WM_RIC_INFO view 5.13
  • ALL_WM_TAB_TRIGGERS view 5.14
  • ALL_WM_VERSIONED_TABLES view 5.15
  • ALL_WM_VT_ERRORS view 5.16
  • ALL_WORKSPACE_PRIVS view 5.17
  • ALL_WORKSPACE_SAVEPOINTS view 5.18
  • ALL_WORKSPACES view 5.19
  • 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.23
    • history views (xxx_HIST) 5.53
  • 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.76

C

  • ChangeWorkspaceType procedure 4.10
  • child row 1.1.4
  • child workspace 1.1.1
  • CommitBulkLoading procedure 4.11
  • CommitDDL procedure 4.12
  • CommitResolve procedure 4.13
  • compressing
  • compression (Workspace Manager)
    • SetCompressWorkspace procedure 4.83
    • WM_COMPRESS_BATCH_SIZES view 5.47
    • WM_COMPRESSIBLE_TABLES view 5.48
  • CompressWorkspace procedure 4.14
  • CompressWorkspaceTree procedure 4.15
  • conflict management 1.16.6, 4.72
    • beginning resolution 4.9
    • committing resolution 4.13
    • rolling back resolution 4.78
    • showing conflicts 4.84
  • conflict resolution
  • conflict views (xxx_CONF) 5.51
  • constraints
    • maximum name length for Workspace Manager 1.1.11
    • support with Workspace Manager 1.9
  • context (session) 1.2
    • GetSessionInfo function 4.37
  • context of current operation
  • continually refreshed workspaces 1.1.9
    • changing workspace type 4.10
    • creating 4.19
  • CopyForUpdate procedure 4.16
  • copying
  • CopyWorkspace procedure 4.17
  • CreateSavepoint procedure 4.18
  • CreateWorkspace procedure 4.19
  • creating

D

  • DBA_REMOVED_WORKSPACES view 5.20
  • DBA_WM_SYS_PRIVS view 5.21
  • DBA_WM_VERSIONED_TABLES view 5.22
  • DBA_WM_VT_ERRORS view 5.23
  • DBA_WORKSPACE_PRIVS view 5.24
  • DBA_WORKSPACE_SAVEPOINTS view 5.25
  • DBA_WORKSPACE_SESSIONS view 5.26
  • DBA_WORKSPACES view 5.27
  • 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
    • CopyWorkspace 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 4.102
  • DDL (data definition language) operations
    • requirements and restrictions 1.8
  • Delete_Topo_Geometry_Layer procedure 4.20
  • DeleteSavepoint procedure 4.21
  • deleting
  • difference views (xxx_DIFF) 5.52
  • DisableVersioning procedure 4.22
  • disabling
    • workspace changes 4.27

E

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

F

  • FindRICSet procedure 4.26
  • foreign keys with version-enabled tables 1.9.1
  • FreezeWorkspace procedure 4.27
  • freezing

G

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

H

  • hierarchy
  • historical data 1.1.12
  • history option
    • EnableVersioning procedure 4.23
  • history views (xxx_HIST) 5.53

I

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

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.55
  • lock management 1.3, 1.16.5
    • with DML operations on tables with referential integrity constraints 1.9.1.1
  • lock mode
  • LockRows procedure 4.55
  • locks
    • disabling 4.86
    • enabling 4.87
    • exclusive 1.3
    • shared 1.3
    • version-exclusive 1.3
    • workspace-exclusive 1.3
  • lock views (xxx_LOCK) 5.54
  • logging of modifications
    • EnableVersioning history option 4.23
    • history views (xxx_HIST) 5.53
  • long transactions 1
  • LT tables
    • created for Workspace Manager infrastructure 1.1.11
    • getting name of _LT (physical) table 4.35

M

  • materialized views
    • version management with 1.13
  • MergeTable procedure 4.56
  • MergeWorkspace procedure 4.57
  • merging
  • metadata space
  • Move_Proc procedure 4.58
  • multilevel referential integrity constraints 1.9.1
  • multiparent workspaces 1.1.10
  • multiworkspace views (xxx_MW) 5.55

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.102

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.48
  • operation context
  • operators for valid time support 3.5
  • Oracle Label Security (OLS)
    • DDL operations on version-enabled tables 1.8
    • granting privileges related to 4.48
  • Oracle sample schemas
    • Workspace Manager example 1.17.2
  • OWM_VERSION
    • Workspace Manager version number 5.50

P

  • parent row 1.1.4
  • parent workspace 1.1.1
    • conflicts with 4.84
  • 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.35
  • privilege management 1.16.4
  • privileges
    • description 1.4
    • getting 4.36
    • granted to PUBLIC user group 1.1.13
    • granting 4.49, 4.50
      • multiparent graph workspaces 4.47
      • OLS-related 4.48
    • grant option 1.4
    • managing 1.4
    • revoking 1.4, 4.74, 4.75
      • multiparent graph workspaces 4.73
    • viewing users having Workspace Manager system-level privileges 5.21
  • PurgeTable procedure 4.59

R

  • RecoverAllMigratingTables procedure 4.60
  • RecoverFromDroppedUser procedure 4.61
  • RecoverMigratingTable procedure 4.62
  • referential integrity constraints
    • finding affected tables 4.26
    • lock management with DML operations 1.9.1.1
  • referential integrity support 1.9.1
    • multilevel constraints 1.9.1
  • refreshing
  • RefreshTable procedure 4.63
  • RefreshWorkspace procedure 4.64
  • removable savepoints 1.1.2
  • RemoveAsParentWorkspace procedure 4.65
  • RemoveDeferredWorkspaces procedure 4.66
  • RemoveUserDefinedHint procedure 4.67
  • RemoveWorkspace procedure 4.68
  • RemoveWorkspaceTree procedure 4.69
  • removing deferred workspaces 4.66
  • removing workspaces 1.1.6, 4.68
  • RenameSavepoint procedure 4.70
  • RenameWorkspace procedure 4.71
  • renaming
  • reserved words and characters with Workspace Manager 1.15
  • ResolveConflicts procedure 4.72
  • resolving conflicts 4.72
  • 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.73
  • RevokeSystemPriv procedure 4.74
  • RevokeWorkspacePriv procedure 4.75
  • revoking privileges 1.4, 4.74, 4.75
    • multiparent graph workspaces 4.73
  • ROLE_WM_PRIVS view 5.28
  • RollbackBulkLoading procedure 4.76
  • RollbackDDL procedure 4.77
  • RollbackResolve procedure 4.78
  • RollbackTable procedure 4.79
  • RollbackToSP procedure 4.80
  • RollbackWorkspace procedure 4.81
  • rolling back
  • row-level security (VPD)
    • Workspace Manager considerations 1.11
  • rows
  • row versions
  • 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
  • sequenced delete operations 3.6.2.1
  • sequenced update operations 3.6.2.1
  • session context 1.2
    • GetSessionInfo function 4.37
  • SetCaptureEvent procedure 4.82
  • SetCompressWorkspace procedure 4.83
  • SetConflictWorkspace procedure 4.84
  • SetDiffVersions procedure 4.85
  • SetLockingOFF procedure 4.86
  • SetLockingON procedure 4.87
  • SetMultiWorkspaces procedure 4.88
  • SET NULL constraints
    • not supported for version-enabled tables 1.9.3
  • SetSystemParameter procedure 4.89
  • SetTriggerEvents procedure 4.90
  • SetValidTimeFilterOFF procedure 4.92
  • SetValidTimeFilterON procedure 4.93
  • SetValidTime procedure 4.91
  • SetWMValidUpdateModeOFF procedure 4.94
  • SetWMValidUpdateModeON procedure 4.95
  • SetWoOverwriteOFF procedure 4.96
  • SetWoOverwriteON procedure 4.97
  • SetWorkspaceLockModeOFF procedure 4.98
  • SetWorkspaceLockModeON procedure 4.99
  • shared locks 1.3, 4.87
  • skeleton tables 1.8
  • spatial topologies
    • version management with 1.14
  • subscription (rule-based) for Workspace Manager events 2.4.3
  • synonyms
  • system parameters
    • for Workspace Manager 1.5
    • shown in WM_INSTALLATION view 5.50
  • system privileges 4.49
    • viewing users having Workspace Manager system-level privileges 5.21

T

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

U

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

V

  • valid time filter
  • valid time support 3
    • altering version-enabled table to add valid time support 4.5
    • operators 3.5
    • setting valid time for session 4.91
  • version-enabled tables
    • definition 1.1
    • maximum name length for Workspace Manager 1.1.11
  • version-exclusive locks 1.3
  • versioning
  • version number
    • Workspace Manager (OWM_VERSION) 5.50
  • VIEW_WO_OVERWRITE mode
  • virtual private databases
    • with Workspace Manager 1.11
  • VPD (virtual private database)
    • with Workspace Manager 1.11

W