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.1.11
- getting name of, 4
A
- ACCESS_ANY_WORKSPACE privilege, 1.4
- ACCESS_WORKSPACE privilege, 1.4
- Add_Topo_Geometry_Layer procedure, 4
- AddAsParentWorkspace procedure, 4
- Advanced Queueing
-
- and Workspace Manager events, 2
- ALL_MP_GRAPH_WORKSPACES view, 5.1
- ALL_MP_PARENT_WORKSPACES view, 5.2
- ALL_VERSION_HVIEW view, 5.3
- ALL_WM_CONS_COLUMNS view, 5.4
- ALL_WM_CONSTRAINTS view, 5.5
- ALL_WM_IND_COLUMNS view, 5.6
- ALL_WM_IND_EXPRESSIONS view, 5.7
- ALL_WM_LOCKED_TABLES view, 5.8
- ALL_WM_MODIFIED_TABLES view, 5.9
- ALL_WM_RIC_INFO view, 5.10
- ALL_WM_TAB_TRIGGERS view, 5.11
- ALL_WM_VERSIONED_TABLES view, 5.12
- ALL_WM_VT_ERRORS view, 5.13
- ALL_WORKSPACE_PRIVS view, 5.14
- ALL_WORKSPACE_SAVEPOINTS view, 5.15
- ALL_WORKSPACES view, 5.16
- ALLOW_CAPTURE_EVENTS system parameter, 1.5, 2.3
- ALLOW_MULTI_PARENT_WORKSPACES system parameter, 1.5
- ALLOW_NESTED_TABLE_COLUMNS system parameter, 1.5
- altering
-
- savepoint description, 4
- version-enabled table to add valid time support, 4
- workspace description, 4
- AlterSavepoint procedure, 4
- AlterVersionedTable procedure, 4
- AlterWorkspace procedure, 4
- asynchronous notification for Workspace Manager events, 2.4.5
- auditing modifications
-
- EnableVersioning history option, 4
- history views (xxx_HIST), 5.44
- auto_commit parameter, 1.1.8
- autocommitting of operations, 1.1.8
B
- BeginBulkLoading procedure, 4
- BeginDDL procedure, 4
- BeginResolve procedure, 4
- bulk loading, 1.7
-
- BeginBulkLoading procedure, 4
- EndBulkLoading procedure, 4
- RollbackBulkLoading procedure, 4
C
- ChangeWorkspaceType procedure, 4
- child workspace, 1.1.1
-
- as alternative to creating savepoint, 1.1.2.1
- merging, 4
- refreshing, 4, 4
- removing, 4
- CommitDDL procedure, 4
- CommitResolve procedure, 4
- compressing
-
- workspaces, 4, 4
- compression
-
- NUMBER_OF_COMPRESS_BATCHES system parameter, 1.5
- compression (Workspace Manager)
-
- SetCompressWorkspace procedure, 4
- WM_COMPRESS_BATCH_SIZES view, 5.37
- WM_COMPRESSIBLE_TABLES view, 5.38
- CompressWorkspace procedure, 4
- CompressWorkspaceTree procedure, 4
- conflict management, 1.16.6, 4
-
- beginning resolution, 4
- committing resolution, 4
- rolling back resolution, 4
- showing conflicts, 4
- conflict resolution
-
- example, 5.42
- conflict views (xxx_CONF), 5.42
- constraints
-
- maximum name length for Workspace Manager, 1.1.11
- support with Workspace Manager, 1.9
- context (session), 1.2
-
- GetSessionInfo function, 4
- context of current operation
-
- getting, 4
- continually refreshed workspaces, 1.1.9
-
- changing workspace type, 4
- CR_WORKSPACE_MODE system parameter, 1.5
- creating, 4
- CopyForUpdate procedure, 4
- CR_WORKSPACE_MODE system parameter, 1.5
- CREATE_ANY_WORKSPACE privilege, 1.4
- CREATE_WORKSPACE privilege, 1.4
- CreateSavepoint procedure, 4
- CreateWorkspace procedure, 4
- creating
-
- savepoints, 4
- workspaces, 4
D
- DBA_WM_SYS_PRIVS view, 5.17
- DBA_WM_VT_ERRORS view, 5.18
- DBA_WORKSPACE_SESSIONS view, 5.19
- DBMS_WM package, 1.1.12
-
- Add_Topo_Geometry_Layer, 4
- AddAsParentWorkspace, 4
- AlterSavepoint, 4
- AlterVersionedTable, 4
- AlterWorkspace, 4
- BeginBulkLoading, 4
- BeginDDL, 4
- BeginResolve, 4
- ChangeWorkspaceType, 4
- CommitDDL, 4
- CommitResolve, 4
- CompressWorkspace, 4
- CompressWorkspaceTree, 4
- CopyForUpdate, 4
- CreateSavepoint, 4
- CreateWorkspace, 4
- Delete_Topo_Geometry_Layer, 4
- DeleteSavepoint, 4
- DisableVersioning, 4
- DropReplicationSupport, 4
- EnableVersioning, 4
- EndBulkLoading, 4
- Export, 4
- FindRICSet, 4
- FreezeWorkspace, 4
- GenerateReplicationSupport, 4
- GetBulkLoadVersion, 4
- GetConflictWorkspace, 4
- GetDiffVersions, 4
- GetLockMode, 4
- GetMultiWorkspaces, 4
- GetOpContext, 4
- GetPhysicalTableName, 4
- GetPrivs, 4
- GetSessionInfo, 4
- GetSystemParameter, 4
- GetValidFrom, 4
- GetValidTill, 4
- GetWMMetadataSpace, 4
- GetWorkspace, 4
- GotoWorkspace, 4
- GrantGraphPriv, 4
- GrantSystemPriv, 4
- GrantWorkspacePriv, 4
- Import, 4
- IsWorkspaceOccupied, 4
- LockRows, 4
- MergeTable, 4
- MergeWorkspace, 4
- Move_Proc, 4
- RecoverAllMigratingTables, 4
- RecoverFromDroppedUser, 4
- RecoverMigratingTable, 4
- RefreshTable, 4
- RefreshWorkspace, 4
- RelocateWriterSite, 4
- RemoveAsParentWorkspace, 4
- RemoveWorkspace, 4
- RemoveWorkspaceTree, 4
- ResolveConflicts, 4
- RevokeGraphPriv, 4
- RevokeSystemPriv, 4
- RevokeWorkspacePriv, 4
- RollbackBulkLoading, 4
- RollbackDDL, 4
- RollbackResolve, 4
- RollbackTable, 4
- RollbackToSP, 4
- RollbackWorkspace, 4
- SetCaptureEvent, 4
- SetCompressWorkspace, 4
- SetConflictWorkspace, 4
- SetDiffVersions, 4
- SetLockingOFF, 4
- SetLockingON, 4
- SetMultiWorkspaces, 4
- SetSystemParameter, 4
- SetTriggerEvents, 4
- SetValidTime, 4
- SetWMValidTimeFilterOFF, 4
- SetWMValidTimeFilterON, 4
- SetWMValidUpdateModeOFF, 4
- SetWMValidUpdateModeON, 4
- SetWoOverwriteOFF, 4
- SetWoOverwriteON, 4
- SetWorkspaceLockModeOFF, 4
- SetWorkspaceLockModeON, 4
- SynchronizeSite, 4
- UnfreezeWorkspace, 4
- UnlockRows, 4
- UseDefaultValuesForNulls, 4
- DBMS_WM public synonym, 4
- DDL (data definition language) operations
-
- requirements and restrictions, 1.8
- Delete_Topo_Geometry_Layer procedure, 4
- DeleteSavepoint procedure, 4
- deleting
-
- savepoints, 4
- workspace, 1.1.6, 4
- difference views (xxx_DIFF), 5.43
- DisableVersioning procedure, 4
- disabling
-
- workspace changes, 4
- downgrading to another Workspace Manager release, B
- DropReplicationSupport procedure, 4
E
- effective dating
-
- See valid time support
- EnableVersioning procedure, 4
- EndBulkLoading procedure, 4
- event parameters, 2.2
- events (Workspace Manager), 2
-
- ALLOW_CAPTURE_EVENTS system parameter, 1.5, 2.3
- asynchronous notification, 2.4.5
- capturing, 4
- event parameters, 2.2
- list of events, 2.1
- listening for, 2.4.4
- WM_EVENTS_INFO view, 5.39
- example
-
- conflict resolution, 5.42
- using Workspace Manager (Oracle sample schemas), 1.17.2
- exclusive locks, 1.3, 4
- explicit savepoints, 1.1.2
- export considerations, 1.6
- Export procedure, 4
F
- FindRICSet procedure, 4
- FIRE_TRIGGERS_FOR_NONDML_EVENTS system parameter, 1.5
- foreign keys with version-enabled tables, 1.9.1
- FREEZE_ANY_WORKSPACE privilege, 1.4
- FREEZE_WORKSPACE privilege, 1.4
- FreezeWorkspace procedure, 4
- freezing
-
- workspace changes, 1.1.5, 4
G
- GenerateReplicationSupport procedure, 4
- GetBulkLoadVersion function, 4
- GetConflictWorkspace function, 4
- GetDiffVersions function, 4
- GetLockMode function, 4
- GetMultiWorkspaces function, 4
- GetOpContext function, 4
- GetPhysicalTableName function, 4
- GetPrivs function, 4
- GetSessionInfo procedure, 4
- GetSystemParameter function, 4
- GetValidFrom function, 4
- GetValidTill function, 4
- GetWMMetadataSpace function, 4
- GetWorkspace function, 4
- GotoWorkspace procedure, 4
- grant option, 1.4
- GrantGraphPriv procedure, 4
- granting
-
- Workspace Manager privileges
-
- multiparent graph workspaces, 4
- system, 4
- workspace, 4
- GrantSystemPriv procedure, 4
- GrantWorkspacePriv procedure, 4
H
- hierarchy
-
- removing, 4
- workspaces, 1.1.1
- history columns
-
- upgrading, B.3
- history management changes for release 10.1, B.3
- history option
-
- EnableVersioning procedure, 4
- history views (xxx_HIST), 5.44
I
- implicit savepoints, 1.1.2
- import considerations, 1.6
- Import procedure, 4
- infrastructure for version-enabling of tables, 1.1.11
- IsWorkspaceOccupied function, 4
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
- LIVE workspace, 1.1.1
- LOB columns with versioned tables, 4
- lock management, 1.3, 1.16.5
- lock mode
-
- getting, 4
- lock views (xxx_LOCK), 5.45
- locking mode
-
- optimistic, 1.5, 1.5
- pessimistic, 1.5, 1.5
- locking table rows, 4
- LockRows procedure, 4
- locks
-
- disabling, 4
- enabling, 4
- exclusive, 1.3
- shared, 1.3
- version-exclusive, 1.3
- workspace-exclusive, 1.3
- logging of modifications
-
- EnableVersioning history option, 4
- history views (xxx_HIST), 5.44
- long transactions, 1
- LT tables
-
- created for Workspace Manager infrastructure, 1.1.11
- getting name of _LT (physical) table, 4
M
- materialized views
-
- version management with, 1.13
- MERGE_ANY_WORKSPACE privilege, 1.4
- MERGE_WORKSPACE privilege, 1.4
- MergeTable procedure, 4
- MergeWorkspace procedure, 4
- merging
-
- table changes, 4
- workspaces, 1.1.3, 4
- metadata space
-
- getting, 4
- migrating to another Workspace Manager release, B
- Move_Proc procedure, 4
- multilevel referential integrity constraints, 1.9.1
- multiparent workspaces, 1.1.10
-
- ALLOW_MULTI_PARENT_WORKSPACES system parameter, 1.5
- multiworkspace views (xxx_MW), 5.46
N
- name length of database objects
-
- maximums for Workspace Manager, 1.1.11
- nested table columns
-
- ALLOW_NESTED_TABLE_COLUMNS system parameter, 1.5
- NONCR_WORKSPACE_MODE system parameter, 1.5
- nonsequenced update operations, 3.6.2.1
- nonwriter sites, C
- null values
-
- using default values for, 4
- NUMBER_OF_COMPRESS_BATCHES system parameter, 1.5
O
- OE.WAREHOUSES table
-
- Workspace Manager example, 1.17.2
- operation context
-
- getting, 4
- 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
- optimistic locking, 1.5, 1.5
- Oracle sample schemas
-
- Workspace Manager example, 1.17.2
- OWM_VERSION
-
- Workspace Manager version number, 5.40
P
- parent workspace, 1.1.1
-
- conflicts with, 4
- partitioned index
-
- cannot be created or dropped on version-enabled table, 1.8
- pessimistic locking, 1.5, 1.5
- physical table name
-
- and Workspace Manager infrastructure, 1.1.11
- getting, 4
- privilege management, 1.16.4
- privileges
-
- ACCESS_ANY_WORKSPACE, 1.4
- ACCESS_WORKSPACE, 1.4
- CREATE_ANY_WORKSPACE, 1.4
- CREATE_WORKSPACE, 1.4
- description, 1.4
- FREEZE_ANY_WORKSPACE, 1.4
- FREEZE_WORKSPACE, 1.4
- getting, 4
- grant option, 1.4
- granted to PUBLIC user group, 1.1.12
- granting, 4, 4
-
- multiparent graph workspaces, 4
- managing, 1.4
- MERGE_ANY_WORKSPACE, 1.4
- MERGE_WORKSPACE, 1.4
- REMOVE_ANY_WORKSPACE, 1.4
- REMOVE_WORKSPACE, 1.4
- revoking, 1.4, 4, 4
-
- multiparent graph workspaces, 4
- ROLLBACK_ANY_WORKSPACE, 1.4
- ROLLBACK_WORKSPACE, 1.4
- viewing users having Workspace Manager system-level privileges, 5.17
R
- RecoverAllMigratingTables procedure, 4
- RecoverFromDroppedUser procedure, 4
- RecoverMigratingTable procedure, 4
- referential integrity constraints
-
- finding affected tables, 4
- referential integrity support, 1.9.1
-
- multilevel constraints, 1.9.1
- refreshing
-
- workspaces, 4
- refreshing tables, 4
- RefreshTable procedure, 4
- RefreshWorkspace procedure, 4
- RelocateWriterSite procedure, 4
- removable savepoints, 1.1.2
- REMOVE_ANY_WORKSPACE privilege, 1.4
- REMOVE_WORKSPACE privilege, 1.4
- RemoveAsParentWorkspace procedure, 4
- RemoveWorkspace procedure, 4
- RemoveWorkspaceTree procedure, 4
- removing workspaces, 1.1.6, 4
- replication
-
- dropping support for, 4
- generating support for, 4
- relocating writer site, 4
- synchronizing local site, 4
- using with Workspace Manager, C
- WM_REPLICATION_INFO view, 5.41
- writer and nonwriter sites, C
- reserved words and characters with Workspace Manager, 1.15
- ResolveConflicts procedure, 4
- resolving conflicts, 4
-
- beginning, 4
- committing, 4
- rolling back, 4
- RETURNING clause
-
- not supported for INSERT or UPDATE on version-enabled tables, 1.1.11
- reverse index
-
- cannot be created or dropped on version-enabled table, 1.8
- RevokeGraphPriv procedure, 4
- RevokeSystemPriv procedure, 4
- RevokeWorkspacePriv procedure, 4
- revoking privileges, 1.4, 4, 4
-
- multiparent graph workspaces, 4
- ROLE_WM_PRIVS view, 5.20
- ROLLBACK_ANY_WORKSPACE privilege, 1.4
- ROLLBACK_WORKSPACE privilege, 1.4
- RollbackBulkLoading procedure, 4
- RollbackDDL procedure, 4
- RollbackResolve procedure, 4
- RollbackTable procedure, 4
- RollbackToSP procedure, 4
- RollbackWorkspace procedure, 4
- rolling back
-
- changes in a table, 4
- workspace changes, 1.1.3, 4
- workspaces to savepoint, 4
- row-level security (VPD)
-
- Workspace Manager considerations, 1.11
- rows
-
- locking, 4
- unlocking, 4
- 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
- as alternative to creating child workspaces, 1.1.2.1
- creating, 4
- deleting, 4
- explicit, 1.1.2
- implicit, 1.1.2
- removable, 1.1.2
- rolling back to, 4
- sequenced delete operations, 3.6.2.1
-
- disabling, 4
- enabling, 4
- sequenced update operations, 3.6.2.1
-
- disabling, 4
- enabling, 4
- session context, 1.2
-
- GetSessionInfo function, 4
- SetCaptureEvent procedure, 4
- SetCompressWorkspace procedure, 4
- SetConflictWorkspace procedure, 4
- SetDiffVersions procedure, 4
- SetLockingOFF procedure, 4
- SetLockingON procedure, 4
- SetMultiWorkspaces procedure, 4
- SetSystemParameter procedure, 4
- SetTriggerEvents procedure, 4
- SetValidTime procedure, 4
- SetWMValidTimeFilterOFF procedure, 4
- SetWMValidTimeFilterON procedure, 4
- SetWMValidUpdateModeOFF procedure, 4
- SetWMValidUpdateModeON procedure, 4
- SetWoOverwriteOFF procedure, 4
- SetWoOverwriteON procedure, 4
- SetWorkspaceLockModeOFF procedure, 4
- SetWorkspaceLockModeON procedure, 4
- shared locks, 1.3, 4
- skeleton tables, 1.8
- spatial topologies
-
- version management with, 1.14
- subscription (rule-based) for Workspace Manager events, 2.4.3
- SynchronizeSite procedure, 4
- synonyms
-
- support for, 1.12
- SYS.OWM_PKG.UpgradeHistoryColumns procedure, B.3
- system parameters
-
- ALLOW_CAPTURE_EVENTS, 1.5
- ALLOW_MULTI_PARENT_WORKSPACES, 1.5
- ALLOW_NESTED_TABLE_COLUMNS, 1.5
- CR_WORKSPACE_MODE, 1.5
- FIRE_TRIGGERS_FOR_NONDML_EVENTS, 1.5
- for Workspace Manager, 1.5
- NONCR_WORKSPACE_MODE, 1.5
- NUMBER_OF_COMPRESS_BATCHES, 1.5
- shown in WM_INSTALLATION view, 5.40
- UNDO_SPACE, 1.5
- USE_TIMESTAMP_TYPE_FOR_HISTORY, 1.5
- system privileges, 4
-
- viewing users having Workspace Manager system-level privileges, 5.17
T
- table management, 1.16.1
- table name
-
- and Workspace Manager infrastructure, 1.1.11
- getting physical table name, 4
- maximum length for Workspace Manager, 1.1.11
- table synonyms, 1.12
- time zone
-
- support with Workspace Manager, B.3
- timestamp with time zone
-
- support with Workspace Manager, B.3
- topologies
-
- version management with, 1.14
- topology geometry layer
-
- adding, 4
- deleting, 4
- trigger events
-
- setting, 4
- triggers on version-enabled tables, 1.10
U
- UNDO_SPACE system parameter, 1.5
- UnfreezeWorkspace procedure, 4
- unfreezing
-
- workspaces, 1.1.5, 4
- unique constraints
-
- support with Workspace Manager, 1.9.2
- unlocking
-
- table rows, 4
- UnlockRows procedure, 4
- UpgradeHistoryColumns procedure, B.3
- upgrading to another Workspace Manager release, B
- USE_TIMESTAMP_TYPE_FOR_HISTORY system parameter, 1.5
- UseDefaultValuesForNulls procedure, 4
- USER_MP_GRAPH_WORKSPACES view, 5.21
- USER_MP_PARENT_WORKSPACES view, 5.22
- USER_WM_CONS_COLUMNS view, 5.23
- USER_WM_CONSTRAINTS view, 5.24
- USER_WM_IND_COLUMNS view, 5.25
- USER_WM_IND_EXPRESSIONS view, 5.26
- USER_WM_LOCKED_TABLES view, 5.27
- USER_WM_MODIFIED_TABLES view, 5.28
- USER_WM_PRIVS view, 5.29
- USER_WM_RIC_INFO view, 5.30
- USER_WM_TAB_TRIGGERS view, 5.31
- USER_WM_VERSIONED_TABLES view, 5.32
- USER_WM_VT_ERRORS view, 5.33
- USER_WORKSPACE_PRIVS view, 5.34
- USER_WORKSPACE_SAVEPOINTS view, 5.35
- USER_WORKSPACES view, 5.36
V
- valid time filter
-
- removing, 4
- setting, 4
- valid time support, 3
-
- altering version-enabled table to add valid time support, 4
- operators, 3.5
- setting valid time for session, 4
- version number
-
- Workspace Manager (OWM_VERSION), 5.40
- version-enabled tables
-
- definition, 1.1
- maximum name length for Workspace Manager, 1.1.11
- version-exclusive locks, 1.3
- versioning
-
- disabling, 4
- enabling, 4
- infrastructure created for, 1.1.11
- VIEW_WO_OVERWRITE mode
-
- disabling, 4
- enabling, 4
- 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.37
- WM_COMPRESSIBLE_TABLES view, 5.38
- WM_CONTAINS operator, 3.5.1
- WM_EQUALS operator, 3.5.2
- WM_EVENTS_INFO view, 5.39
- WM_GREATERTHAN operator, 3.5.3
- WM_INSTALLATION view, 5.40
- 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
- WM_REPLICATION_INFO view, 5.41
- WMSYS schema and user, 1.1.12
- workspace lock mode
-
- disabling, 4
- enabling, 4
- Workspace Manager metadata space
-
- getting, 4
- workspace-exclusive locks, 1.3
- workspaces
-
- altering description of, 4
- changing type, 4
- child
-
- as alternative to creating savepoints, 1.1.2.1
- compressing, 4, 4
- continually refreshed, 1.1.9, 4, 4
-
- CR_WORKSPACE_MODE system parameter, 1.5
- creating, 4
- freezing, 1.1.5, 4
- getting, 4
- going to, 4
- hierarchy, 1.1.1
- management of, 1.1, 1.16.2
- merging, 1.1.3
- multiparent, 1.1.10
-
- ALLOW_MULTI_PARENT_WORKSPACES system parameter, 1.5
- rolling back, 1.1.3
- unfreezing, 1.1.5, 4
- writer site, C