Index

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
    • getting name of 1

A

  • Add_Topo_Geometry_Layer procedure 1
  • AddAsParentWorkspace procedure 1
  • AddUserDefinedHint procedure 1
  • Advanced Queuing
    • and Workspace Manager events 1
  • ALL_MP_GRAPH_WORKSPACES view 1
  • ALL_MP_PARENT_WORKSPACES view 1
  • ALL_REMOVED_WORKSPACES view 1
  • ALL_VERSION_HVIEW view 1
  • ALL_WM_CONS_COLUMNS view 1
  • ALL_WM_CONSTRAINTS view 1
  • ALL_WM_IND_COLUMNS view 1
  • ALL_WM_IND_EXPRESSIONS view 1
  • ALL_WM_LOCKED_TABLES view 1
  • ALL_WM_MODIFIED_TABLES view 1
  • ALL_WM_POLICIES view 1
  • ALL_WM_RIC_INFO view 1
  • ALL_WM_TAB_TRIGGERS view 1
  • ALL_WM_VERSIONED_TABLES view 1
  • ALL_WM_VT_ERRORS view 1
  • ALL_WORKSPACE_PRIVS view 1
  • ALL_WORKSPACE_SAVEPOINTS view 1
  • ALL_WORKSPACES view 1
  • ALLOW_CAPTURE_EVENTS system parameter 1
  • altering
    • savepoint description 1
    • version-enabled table to add valid time support 1
    • workspace description 1
  • AlterSavepoint procedure 1
  • AlterVersionedTable procedure 1
  • AlterWorkspace procedure 1
  • asynchronous notification for Workspace Manager events 1
  • auditing modifications
    • EnableVersioning history option 1
    • history views (xxx_HIST) 1
  • auto_commit parameter 1
  • autocommitting of operations 1

B

  • base row 1
  • BeginBulkLoading procedure 1
  • BeginDDL procedure 1
  • BeginResolve procedure 1
  • bulk loading
    • BeginBulkLoading procedure 1
    • CommitBulkLoading procedure 1
    • RollbackBulkLoading procedure 1

C

  • ChangeWorkspaceType procedure 1
  • child row 1
  • child workspace
    • as alternative to creating savepoint 1
    • merging 1
    • refreshing 1 , 2
    • removing 1
  • CommitBulkLoading procedure 1
  • CommitDDL procedure 1
  • CommitResolve procedure 1
  • compressing
    • workspaces 1 , 2
  • compression (Workspace Manager)
    • SetCompressWorkspace procedure 1
    • WM_COMPRESS_BATCH_SIZES view 1
    • WM_COMPRESSIBLE_TABLES view 1
  • CompressWorkspace procedure 1
  • CompressWorkspaceTree procedure 1
  • conflict management
    • beginning resolution 1
    • committing resolution 1
    • rolling back resolution 1
    • showing conflicts 1
  • conflict resolution
    • example 1
  • conflict views (xxx_CONF) 1
  • constraints
    • maximum name length for Workspace Manager 1
    • support with Workspace Manager 1
  • context (session)
    • GetSessionInfo function 1
  • context of current operation
    • getting 1
  • continually refreshed workspaces
    • changing workspace type 1
    • creating 1
  • CopyForUpdate procedure 1
  • CreateSavepoint procedure 1
  • CreateWorkspace procedure 1
  • creating
    • savepoints 1
    • workspaces 1

D

  • DBA_REMOVED_WORKSPACES view 1
  • DBA_WM_SYS_PRIVS view 1
  • DBA_WM_VERSIONED_TABLES view 1
  • DBA_WM_VT_ERRORS view 1
  • DBA_WORKSPACE_PRIVS view 1
  • DBA_WORKSPACE_SAVEPOINTS view 1
  • DBA_WORKSPACE_SESSIONS view 1
  • DBA_WORKSPACES view 1
  • DBMS_WM package
    • Add_Topo_Geometry_Layer 1
    • AddAsParentWorkspace 1
    • AddUserDefinedHint 1
    • AlterSavepoint 1
    • AlterVersionedTable 1
    • AlterWorkspace 1
    • BeginBulkLoading 1
    • BeginDDL 1
    • BeginResolve 1
    • ChangeWorkspaceType 1
    • CommitBulkLoading 1
    • CommitDDL 1
    • CommitResolve 1
    • CompressWorkspace 1
    • CompressWorkspaceTree 1
    • CopyForUpdate 1
    • CreateSavepoint 1
    • CreateWorkspace 1
    • Delete_Topo_Geometry_Layer 1
    • DeleteSavepoint 1
    • DisableVersioning 1
    • EnableVersioning 1
    • Export 1
    • Export_Schemas 1
    • FindRICSet 1
    • FreezeWorkspace 1
    • GetBulkLoadVersion 1
    • GetConflictWorkspace 1
    • GetDiffVersions 1
    • GetLockMode 1
    • GetMultiWorkspaces 1
    • GetOpContext 1
    • GetOriginalDDL 1
    • GetPhysicalTableName 1
    • GetPrivs 1
    • GetSessionInfo 1
    • GetSystemParameter 1
    • GetValidFrom 1
    • GetValidTill 1
    • GetVersion 1
    • GetWMMetadataSpace 1
    • GetWorkspace 1
    • GotoDate 1
    • GotoSavepoint 1
    • GotoWorkspace 1
    • GrantGraphPriv 1
    • GrantPrivsOnPolicy 1
    • GrantSystemPriv 1
    • GrantWorkspacePriv 1
    • Import 1
    • Import_Schemas 1
    • Initialize_After_Import 1
    • IsWorkspaceOccupied 1
    • LockRows 1
    • MergeTable 1
    • MergeWorkspace 1
    • Move_Proc 1
    • PurgeTable 1
    • RecoverAllMigratingTables 1
    • RecoverFromDroppedUser 1
    • RecoverMigratingTable 1
    • RefreshTable 1
    • RefreshWorkspace 1
    • RemoveAsParentWorkspace 1
    • RemoveDeferredWorkspaces 1
    • RemoveUserDefinedHint 1
    • RemoveWorkspace 1
    • RemoveWorkspaceTree 1
    • RenameSavepoint 1
    • RenameWorkspace 1
    • ResolveConflicts 1
    • RevokeGraphPriv 1
    • RevokeSystemPriv 1
    • RevokeWorkspacePriv 1
    • RollbackBulkLoading 1
    • RollbackDDL 1
    • RollbackResolve 1
    • RollbackTable 1
    • RollbackToSP 1
    • RollbackWorkspace 1
    • SetCaptureEvent 1
    • SetCompressWorkspace 1
    • SetConflictWorkspace 1
    • SetDiffVersions 1
    • SetLockingOFF 1
    • SetLockingON 1
    • SetMultiWorkspaces 1
    • SetSystemParameter 1
    • SetTriggerEvents 1
    • SetValidTime 1
    • SetValidTimeFilterOFF 1
    • SetValidTimeFilterON 1
    • SetWMValidUpdateModeOFF 1
    • SetWMValidUpdateModeON 1
    • SetWoOverwriteOFF 1
    • SetWoOverwriteON 1
    • SetWorkspaceLockModeOFF 1
    • SetWorkspaceLockModeON 1
    • UnfreezeWorkspace 1
    • UnlockRows 1
    • UseDefaultValuesForNulls 1
  • DDL (data definition language) operations
    • requirements and restrictions 1
  • Delete_Topo_Geometry_Layer procedure 1
  • DeleteSavepoint procedure 1
  • deleting
    • deferred workspace 1
    • savepoints 1
    • workspace 1 , 2
  • difference views (xxx_DIFF) 1
  • DisableVersioning procedure 1
  • disabling
    • workspace changes 1

E

  • effective dating
    • See: valid time support
  • EnableVersioning procedure 1
  • event parameters 1
  • events (Workspace Manager)
    • ALLOW_CAPTURE_EVENTS system parameter 1
    • asynchronous notification 1
    • capturing 1
    • event parameters 1
    • listening for 1
    • list of events 1
    • WM_EVENTS_INFO view 1
  • example
    • conflict resolution 1
    • using Workspace Manager (Oracle sample schemas) 1
  • exclusive locks 1 , 2
  • explicit savepoints 1
  • Export_Schemas procedure 1
  • export considerations 1
  • Export procedure 1

F

  • FindRICSet procedure 1
  • foreign keys with version-enabled tables 1
  • FreezeWorkspace procedure 1
  • freezing
    • workspace changes 1 , 2

G

  • GetBulkLoadVersion function 1
  • GetConflictWorkspace function 1
  • GetDiffVersions function 1
  • GetLockMode function 1
  • GetMultiWorkspaces function 1
  • GetOpContext function 1
  • GetOriginalDDL procedure 1
  • GetPhysicalTableName function 1
  • GetPrivs function 1
  • GetSessionInfo procedure 1
  • GetSystemParameter function 1
  • GetValidFrom function 1
  • GetValidTill function 1
  • GetVersion function 1
  • GetWMMetadataSpace function 1
  • GetWorkspace function 1
  • GotoDate procedure 1
  • GotoSavepoint procedure 1
  • GotoWorkspace procedure 1
  • GrantGraphPriv procedure 1
  • granting
    • Workspace Manager privileges
      • multiparent graph workspaces 1
      • OLS-related 1
      • system 1
      • workspace 1
  • grant option 1
  • GrantPrivsOnPolicy procedure 1
  • GrantSystemPriv procedure 1
  • GrantWorkspacePriv procedure 1

H

  • hierarchy
    • removing 1
    • workspaces 1
  • historical data 1
  • history option
    • EnableVersioning procedure 1
  • history views (xxx_HIST) 1

I

  • implicit savepoints 1
  • Import_Schemas procedure 1
  • import considerations 1
  • Import procedure 1
  • infrastructure for version-enabling of tables 1
  • Initialize_After_Import procedure 1
  • invisible index
    • supported on version-enabled table 1
  • IsWorkspaceOccupied function 1

J

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

L

  • LATEST savepoint 1
  • length of object names
    • maximums for Workspace Manager 1
  • LOB columns with versioned tables 1
  • locking table rows 1
  • lock management
    • with DML operations on tables with referential integrity constraints 1
  • lock mode
    • getting 1
  • LockRows procedure 1
  • locks
    • disabling 1
    • enabling 1
    • exclusive 1
    • shared 1
    • version-exclusive 1
    • workspace-exclusive 1
  • lock views (xxx_LOCK) 1
  • logging of modifications
    • EnableVersioning history option 1
    • history views (xxx_HIST) 1
  • long transactions 1
  • LT tables
    • created for Workspace Manager infrastructure 1
    • getting name of _LT (physical) table 1

M

  • materialized views
    • version management with 1
  • MergeTable procedure 1
  • MergeWorkspace procedure 1
  • merging
    • table changes 1
    • workspaces 1 , 2
  • metadata space
    • getting 1
  • Move_Proc procedure 1
  • multilevel referential integrity constraints 1
  • multiparent workspaces 1
  • multiworkspace views (xxx_MW) 1

N

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

O

  • OE.WAREHOUSES table
    • Workspace Manager example 1
  • OLS (Oracle Label Security)
    • DDL operations on version-enabled tables 1
    • granting privileges related to 1
  • operation context
    • getting 1
  • operators for valid time support
    • WM_CONTAINS 1
    • WM_EQUALS 1
    • WM_GREATERTHAN 1
    • WM_INTERSECTION 1
    • WM_LDIFF 1
    • WM_LESSTHAN 1
    • WM_MEETS 1
    • WM_OVERLAPS 1
    • WM_RDIFF 1
  • Oracle Label Security (OLS)
    • DDL operations on version-enabled tables 1
    • granting privileges related to 1
  • Oracle sample schemas
    • Workspace Manager example 1
  • OWM_VERSION
    • Workspace Manager version number 1

P

  • parent row 1
  • parent workspace
    • conflicts with 1
  • partitioned index
    • cannot be created or dropped on version-enabled table 1
  • physical table name
    • and Workspace Manager infrastructure 1
    • getting 1
  • privilege management 1
  • privileges
    • description 1
    • getting 1
    • granted to PUBLIC user group 1
    • granting
      • multiparent graph workspaces 1
      • OLS-related 1
    • grant option 1
    • managing 1
    • revoking
      • multiparent graph workspaces 1
    • viewing users having Workspace Manager system-level privileges 1
  • PurgeTable procedure 1

R

  • RecoverAllMigratingTables procedure 1
  • RecoverFromDroppedUser procedure 1
  • RecoverMigratingTable procedure 1
  • referential integrity constraints
    • finding affected tables 1
    • lock management with DML operations 1
  • referential integrity support
    • multilevel constraints 1
  • refreshing
    • tables 1
    • workspaces 1
  • RefreshTable procedure 1
  • RefreshWorkspace procedure 1
  • removable savepoints 1
  • RemoveAsParentWorkspace procedure 1
  • RemoveDeferredWorkspaces procedure 1
  • RemoveUserDefinedHint procedure 1
  • RemoveWorkspace procedure 1
  • RemoveWorkspaceTree procedure 1
  • removing deferred workspaces 1
  • removing workspaces 1 , 2
  • RenameSavepoint procedure 1
  • RenameWorkspace procedure 1
  • renaming
    • savepoint 1
    • workspace 1
  • reserved words and characters with Workspace Manager 1
  • ResolveConflicts procedure 1
  • resolving conflicts
    • beginning 1
    • committing 1
    • rolling back 1
  • RETURNING clause
    • not supported for INSERT or UPDATE on version-enabled tables 1
  • reverse index
    • supported on version-enabled table 1
  • RevokeGraphPriv procedure 1
  • RevokeSystemPriv procedure 1
  • RevokeWorkspacePriv procedure 1
  • revoking privileges
    • multiparent graph workspaces 1
  • ROLE_WM_PRIVS view 1
  • RollbackBulkLoading procedure 1
  • RollbackDDL procedure 1
  • RollbackResolve procedure 1
  • RollbackTable procedure 1
  • RollbackToSP procedure 1
  • RollbackWorkspace procedure 1
  • rolling back
    • changes in a table 1
    • workspace changes 1 , 2
    • workspaces to savepoint 1
  • row-level security (VPD)
    • Workspace Manager considerations 1
  • rows
    • locking 1
    • unlocking 1
  • row versions
    • creation of 1
  • rule-based subscription for Workspace Manager events 1

S

  • sample schemas
    • Workspace Manager example 1
  • savepoint management 1
  • savepoints
    • altering description of 1
    • as alternative to creating child workspaces 1
    • creating 1
    • deleting 1
    • explicit 1
    • going to 1
    • implicit 1
    • removable 1
    • renaming 1
    • rolling back to 1
  • sequenced delete operations
    • disabling 1
    • enabling 1
  • sequenced update operations
    • disabling 1
    • enabling 1
  • session context
    • GetSessionInfo function 1
  • SetCaptureEvent procedure 1
  • SetCompressWorkspace procedure 1
  • SetConflictWorkspace procedure 1
  • SetDiffVersions procedure 1
  • SetLockingOFF procedure 1
  • SetLockingON procedure 1
  • SetMultiWorkspaces procedure 1
  • SET NULL constraints
    • not supported for version-enabled tables 1
  • SetSystemParameter procedure 1
  • SetTriggerEvents procedure 1
  • SetValidTimeFilterOFF procedure 1
  • SetValidTimeFilterON procedure 1
  • SetValidTime procedure 1
  • SetWMValidUpdateModeOFF procedure 1
  • SetWMValidUpdateModeON procedure 1
  • SetWoOverwriteOFF procedure 1
  • SetWoOverwriteON procedure 1
  • SetWorkspaceLockModeOFF procedure 1
  • SetWorkspaceLockModeON procedure 1
  • shared locks 1 , 2
  • skeleton tables 1
  • spatial topologies
    • version management with 1
  • subscription (rule-based) for Workspace Manager events 1
  • synonyms
    • support for 1
  • system parameters
    • for Workspace Manager 1
    • shown in WM_INSTALLATION view 1
  • system privileges
    • viewing users having Workspace Manager system-level privileges 1

T

  • table management 1
  • table name
    • and Workspace Manager infrastructure 1
    • getting physical table name 1
    • maximum length for Workspace Manager 1
  • table synonyms 1
  • topologies
    • version management with 1
  • topology geometry layer
    • adding 1
    • deleting 1
  • trigger events
    • setting 1
  • triggers on version-enabled tables 1

U

  • UnfreezeWorkspace procedure 1
  • unfreezing
    • workspaces 1 , 2
  • unique constraints
    • support with Workspace Manager 1
  • unlocking
    • table rows 1
  • UnlockRows procedure 1
  • UseDefaultValuesForNulls procedure 1
  • USER_MP_GRAPH_WORKSPACES view 1
  • USER_MP_PARENT_WORKSPACES view 1
  • USER_REMOVED_WORKSPACES view 1
  • USER_WM_CONS_COLUMNS view 1
  • USER_WM_CONSTRAINTS view 1
  • USER_WM_IND_COLUMNS view 1
  • USER_WM_IND_EXPRESSIONS view 1
  • USER_WM_LOCKED_TABLES view 1
  • USER_WM_MODIFIED_TABLES view 1
  • USER_WM_POLICIES view 1
  • USER_WM_PRIVS view 1
  • USER_WM_RIC_INFO view 1
  • USER_WM_TAB_TRIGGERS view 1
  • USER_WM_VERSIONED_TABLES view 1
  • USER_WM_VT_ERRORS view 1
  • USER_WORKSPACE_PRIVS view 1
  • USER_WORKSPACE_SAVEPOINTS view 1
  • USER_WORKSPACES view 1
  • user-defined hints
    • adding 1
    • removing 1

V

  • valid time filter
    • removing 1
    • setting 1
  • valid time support
    • altering version-enabled table to add valid time support 1
    • operators 1
    • setting valid time for session 1
  • version-enabled tables
    • definition 1
    • maximum name length for Workspace Manager 1
  • version-exclusive locks 1
  • versioning
    • disabling 1
    • enabling 1
    • infrastructure created for 1
  • version number
    • Workspace Manager (OWM_VERSION) 1
  • VIEW_WO_OVERWRITE mode
    • disabling 1
    • enabling 1
  • virtual private databases
    • with Workspace Manager 1
  • VPD (virtual private database)
    • with Workspace Manager 1

W

  • WM_ADMIN_ROLE role 1
  • WM_COMPRESS_BATCH_SIZES view 1
  • WM_COMPRESSIBLE_TABLES view 1
  • WM_CONTAINS operator 1
  • WM_EQUALS operator 1
  • WM_EVENTS_INFO view 1
  • WM_GREATERTHAN operator 1
  • WM_INSTALLATION view 1
  • WM_INTERSECTION operator 1
  • WM_LDIFF operator 1
  • WM_LESSTHAN operator 1
  • WM_MEETS operator 1
  • WM_OVERLAPS operator 1
  • WM_RDIFF operator 1
  • WMSYS schema and user 1
  • workspace-exclusive locks 1
  • workspace lock mode
    • disabling 1
    • enabling 1
  • Workspace Manager metadata space
    • getting 1
  • Workspace Manager version
    • getting 1
  • workspaces
    • altering description of 1
    • changing type 1
    • child
      • as alternative to creating savepoints 1
    • compressing 1 , 2
    • continually refreshed 1 , 2 , 3
    • creating 1
    • freezing 1 , 2
    • getting 1
    • going to 1
    • hierarchy 1
    • management of 1 , 2
    • merging 1
    • multiparent 1
    • renaming 1
    • rolling back 1
    • unfreezing 1 , 2