Index
A
B
C
D
E
F
G
H
I
L
M
O
P
R
S
T
U
V
W
A
- ACCESS_ANY_WORKSPACE privilege, 1-10
- ACCESS_WORKSPACE privilege, 1-10
- ALL_VERSION_HVIEW view, 3-2
- ALL_WM_LOCKED_TABLES view, 3-3
- ALL_WM_MODIFIED_TABLES view, 3-3
- ALL_WM_RIC_INFO view, 3-4
- ALL_WM_TAB_TRIGGERS view, 3-4
- ALL_WM_VERSIONED_TABLES view, 3-6
- ALL_WORKSPACE_PRIVS view, 3-6
- ALL_WORKSPACE_SAVEPOINTS view, 3-7
- ALL_WORKSPACES view, 3-7
- altering savepoints, 2-2
- altering workspaces, 2-3
- AlterSavepoint procedure, 2-2
- AlterWorkspace procedure, 2-3
- auditing modifications
- EnableVersioning history option, 2-22
- history views (xxx_HIST), 3-14
- auto_commit parameter, 1-6
- autocommitting of operations, 1-6
B
- BeginResolve procedure, 2-4
C
- child workspace, 1-3
- merging, 2-48, 2-52
- refreshing, 2-50, 2-52
- removing, 2-56
- CommitResolve procedure, 2-5
- compressing workspaces, 2-6, 2-9
- CompressWorkspace procedure, 2-6
- CompressWorkspaceTree procedure, 2-9
- conflict management, 1-16, 2-58
- beginning resolution, 2-4
- committing resolution, 2-5
- rolling back resolution, 2-65
- showing conflicts, 2-72
- conflict resolution
- example, 3-12
- conflict views (xxx_CONF), 3-11
- context of current operation
- getting, 2-29
- continually refreshed workspace, 2-15
- CopyForUpdate procedure, 2-11
- CREATE_ANY_WORKSPACE privilege, 1-10
- CREATE_WORKSPACE privilege, 1-10
- CreateSavepoint procedure, 2-13
- CreateWorkspace procedure, 2-15
- creating
- new workspace, 2-15
- savepoint, 2-13
- custom databases
- installation of Workspace Manager required, A-1
D
- Database Configuration Assistant (DBCA)
- no separate Workspace Manager installation required, A-1
- database table, 1-2
- DBA_WORKSPACE_SESSIONS view, 3-8
- DBMS_WM public synonym, 2-1
- DeleteSavepoint procedure, 2-17
- deleting
- savepoint, 2-17
- workspace, 1-8, 2-54
- difference views (xxx_DIFF), 3-12
- DisableVersioning procedure, 2-19
- disabling changes, 2-23
- unfreezing, 2-86
E
- EnableVersioning procedure, 2-21
- error messages, B-1
- example
- conflict resolution, 3-12
- using Workspace Manager (many operations), 1-17
- exclusive locks, 1-9, 2-76
- export considerations, 1-11
F
- foreign keys with version-enabled tables, 1-11
- FreezeWorkspace procedure, 2-23
- freezing workspace changes, 1-7, 2-23
- unfreezing, 1-7, 2-86
- functions
- GetConflictWorkspace, 2-25
- GetDiffVersions, 2-26
- GetLockMode, 2-27
- GetMultiWorkspaces, 2-28
- GetOpContext, 2-29
- GetPrivs, 2-30
- GetWorkspace, 2-31
- IsWorkspaceOccupied, 2-42
- reference information, 2-1
- See also
G
- GetConflictWorkspace function, 2-25
- GetDiffVersions function, 2-26
- GetLockMode function, 2-27
- GetMultiWorkspaces, 2-28
- GetOpContext function, 2-29
- GetPrivs function, 2-30
- GetWorkspace function, 2-31
- GotoWorkspace procedure, 2-35
- grant option, 1-10
- granting privileges
- system, 2-37
- workspace, 2-39
- GrantSystemPriv procedure, 2-37
- GrantWorkspacePriv procedure, 2-39
H
- hierarchy, 1-3
- removing, 2-56
- history option
- EnableVersioning procedure, 2-21
- history views (xxx_HIST), 3-14
I
- import considerations, 1-11
- installation of Workspace Manager
- with custom databases, A-1
- IsWorkspaceOccupied function, 2-42
L
- LATEST savepoint, 1-5
- LIVE workspace, 1-3
- LOB columns with versioned tables, 2-11
- lock management, 1-8, 1-15
- lock mode
- getting, 2-27
- lock views (xxx_LOCK), 3-14
- locking table rows, 2-43
- LockRows procedure, 2-43
- locks
- disabling, 2-75
- enabling, 2-76
- exclusive, 1-9
- shared, 1-9
- logging of modifications
- EnableVersioning history option, 2-22
- history views (xxx_HIST), 3-14
- long transaction, 1-1
M
- MERGE_ANY_WORKSPACE privilege, 1-10
- MERGE_WORKSPACE privilege, 1-10
- MergeTable procedure, 2-45, 2-52
- MergeWorkspace procedure, 2-48
- merging
- table changes, 2-45
- tables, 2-52
- workspaces, 1-5, 2-48
- messages
- error, B-1
- multiworkspace views (xxx_MW), 3-15
O
- operation context
- getting, 2-29
P
- parent workspace, 1-3
- conflicts with, 2-72
- privilege management, 1-15
- privileges
- ACCESS_ANY_WORKSPACE, 1-10
- ACCESS_WORKSPACE, 1-10
- CREATE_ANY_WORKSPACE, 1-10
- CREATE_WORKSPACE, 1-10
- description, 1-9
- getting, 2-30
- grant option, 1-10
- granting, 2-37, 2-39
- managing, 1-9
- MERGE_ANY_WORKSPACE, 1-10
- MERGE_WORKSPACE, 1-10
- REMOVE_ANY_WORKSPACE, 1-10
- REMOVE_WORKSPACE, 1-10
- revoking, 1-11, 2-61, 2-63
- ROLLBACK_ANY_WORKSPACE, 1-10
- ROLLBACK_WORKSPACE, 1-10
- procedures
- AlterSavepoint, 2-2
- AlterWorkspace, 2-3
- BeginResolve, 2-4
- CommitResolve, 2-5
- CompressWorkspace, 2-6
- CompressWorkspaceTree, 2-9
- CopyForUpdate, 2-11
- CreateSavepoint, 2-13
- CreateWorkspace, 2-15
- DeleteSavepoint, 2-17
- DisableVersioning, 2-19
- EnableVersioning, 2-21
- FreezeWorkspace, 2-23
- GotoWorkspace, 2-35
- GrantSystemPriv, 2-37
- GrantWorkspacePriv, 2-39
- LockRows, 2-43
- MergeTable, 2-45, 2-52
- MergeWorkspace, 2-48
- RefreshTable, 2-50
- RefreshWorkspace, 2-52
- RemoveWorkspace, 2-54
- RemoveWorkspaceTree, 2-56
- ResolveConflicts, 2-58
- RevokeSystemPriv, 2-61
- RevokeWorkspacePriv, 2-63
- RollbackResolve, 2-65
- RollbackTable, 2-66
- RollbackToSP, 2-68
- RollbackWorkspace, 2-70
- SetConflictWorkspace, 2-72
- SetDiffVersions, 2-73
- SetLockingOFF, 2-75
- SetLockingON, 2-76
- SetMultiWorkspaces, 2-78
- SetWoOverwriteOFF, 2-80
- SetWoOverwriteON, 2-82
- SetWorkspaceLockModeOFF, 2-83
- SetWorkspaceLockModeON, 2-84
- UnfreezeWorkspace, 2-86
- UnlockRows, 2-87
- See also
R
- record management, 1-2
- referential integrity support, 1-11
- refreshing tables, 2-50
- refreshing workspaces, 2-52
- RefreshTable procedure, 2-50
- RefreshWorkspace procedure, 2-52
- REMOVE_ANY_WORKSPACE privilege, 1-10
- REMOVE_WORKSPACE privilege, 1-10
- RemoveWorkspace procedure, 2-54
- RemoveWorkspaceTree procedure, 2-56
- removing workspaces, 1-8, 2-54
- ResolveConflicts procedure, 2-58
- resolving conflicts, 2-58
- beginning, 2-4
- committing, 2-5
- rolling back, 2-65
- RevokeSystemPriv procedure, 2-61
- RevokeWorkspacePriv procedure, 2-63
- revoking privileges, 1-11, 2-61, 2-63
- ROLE_WM_PRIVS view, 3-9
- ROLLBACK_ANY_WORKSPACE privilege, 1-10
- ROLLBACK_WORKSPACE privilege, 1-10
- RollbackResolve procedure, 2-65
- RollbackTable procedure, 2-66
- RollbackToSP procedure, 2-68
- RollbackWorkspace procedure, 2-70
- rolling back tables, 2-66
- rolling back workspaces, 1-5, 2-70
- to savepoint, 2-68
- rows
- locking, 2-43
- unlocking, 2-87
S
- savepoint, 1-4
- altering, 2-2
- creating, 2-13
- deleting, 2-17
- rolling back to, 2-68
- savepoint management, 1-14
- SetConflictWorkspace procedure, 2-72
- SetDiffVersions procedure, 2-73
- SetLockingON procedure, 2-75, 2-76
- SetMultiWorkspaces procedure, 2-78
- SetWoOverwriteOFF procedure, 2-80
- SetWoOverwriteON procedure, 2-82
- SetWorkspaceLockModeOFF procedure, 2-83
- SetWorkspaceLockModeON procedure, 2-84
- shared locks, 1-9, 2-76
- short transaction, 1-1
- system privileges, 2-37
T
- table management, 1-13
- triggers on version-enabled tables, 1-12
U
- UnfreezeWorkspace procedure, 2-86
- unfreezing workspaces, 1-7
- unlocking table rows, 2-87
- UnlockRows procedure, 2-87
- USER_WM_LOCKED_TABLES view, 3-9
- USER_WM_MODIFIED_TABLES view, 3-10
- USER_WM_PRIVS view, 3-10
- USER_WM_RIC_INFO view, 3-10
- USER_WM_TAB_TRIGGERS view, 3-10
- USER_WM_VERSIONED_TABLES view, 3-11
- USER_WORKSPACE_PRIVS view, 3-11
- USER_WORKSPACE_SAVEPOINTS view, 3-11
- USER_WORKSPACES view, 3-11
V
- versioning
- disabling, 2-19
- enabling, 2-21
- versions of records, 1-2
- VIEW_WO_OVERWRITE mode
- disabling, 2-80
- enabling, 2-82
W
- WM_ADMIN_ROLE role, 1-10
- workspace
- continually refreshed, 2-15
- creating, 2-15
- freezing, 1-7, 2-23
- getting, 2-31
- hierarchy, 1-3
- management, 1-3, 1-13
- merging, 1-5
- rolling back, 1-5
- selecting, 2-35
- unfreezing, 1-7, 2-86
- workspace lock mode
- disabling, 2-83
- enabling, 2-84