Index
A B C D E F G H I L M N O P R S T U V W
A
- ACCESS_ANY_WORKSPACE privilege, 1-13
- ACCESS_WORKSPACE privilege, 1-13
- ALL_VERSION_HVIEW view, 3-3
- 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-5
- ALL_WM_VERSIONED_TABLES view, 3-6
- ALL_WM_VT_ERRORS view, 3-7
- ALL_WORKSPACE_PRIVS view, 3-8
- ALL_WORKSPACE_SAVEPOINTS view, 3-8
- ALL_WORKSPACES view, 3-9
- altering
- savepoint description, 2-2
- workspace description, 2-3
- AlterSavepoint procedure, 2-2
- AlterWorkspace procedure, 2-3
- auditing modifications
- EnableVersioning history option, 2-29
- history views (xxx_HIST), 3-17
- auto_commit parameter, 1-10
- autocommitting of operations, 1-10
B
- BeginDDL procedure, 2-4
- BeginResolve procedure, 2-6
C
- child workspace, 1-4
- as alternative to creating savepoint, 1-6
- merging, 2-61, 2-69
- refreshing, 2-67, 2-69
- removing, 2-75
- CommitDDL procedure, 2-7
- CommitResolve procedure, 2-9
- compressing
- workspaces, 2-10, 2-13
- CompressWorkspace procedure, 2-10
- CompressWorkspaceTree procedure, 2-13
- conflict management, 1-24, 2-77
- beginning resolution, 2-6
- committing resolution, 2-9
- rolling back resolution, 2-86
- showing conflicts, 2-93
- conflict resolution
- example, 3-15
- conflict views (xxx_CONF), 3-14
- context (session), 1-11
- GetSessionInfo function, 2-42
- context of current operation
- getting, 2-40
- continually refreshed workspaces, 2-19
- CopyForUpdate procedure, 2-15
- CREATE_ANY_WORKSPACE privilege, 1-14
- CREATE_WORKSPACE privilege, 1-13
- CreateSavepoint procedure, 2-17
- CreateWorkspace procedure, 2-19
- creating
- savepoints, 2-17
- workspaces, 2-19
- custom databases
- installation of Workspace Manager required, A-1
D
- Database Configuration Assistant (DBCA)
- no separate Workspace Manager installation required, A-1
- DBA_WORKSPACE_SESSIONS view, 3-11
- DBMS_WM public synonym, 2-1
- DDL (data definition language) operations
- beginning, 2-4
- committing, 2-7
- requirements and restrictions, 1-15
- rolling back, 2-84
- DeleteSavepoint procedure, 2-22
- deleting
- savepoints, 2-22
- workspace, 1-9, 2-73
- difference views (xxx_DIFF), 3-15
- DisableVersioning procedure, 2-24
- disabling
- workspace changes, 2-31
- downgrading to another Workspace Manager release, B-1
- DropReplicationSupport procedure, 2-27
E
- EnableVersioning procedure, 2-28
- error messages, D-1
- example
- conflict resolution, 3-15
- using Workspace Manager (many operations), 1-25
- exclusive locks, 1-13, 2-98
- explicit savepoints, 1-5
- export considerations, 1-15
F
- foreign keys with version-enabled tables, 1-17
- FREEZE_ANY_WORKSPACE privilege, 1-14
- FREEZE_WORKSPACE privilege, 1-14
- FreezeWorkspace procedure, 2-31
- freezing
- workspace changes, 1-8, 2-31
- functions
- GetConflictWorkspace, 2-36
- GetDiffVersions, 2-37
- GetLockMode, 2-38
- GetMultiWorkspaces, 2-39
- GetOpContext, 2-40
- GetPrivs, 2-41
- GetSessionInfo, 2-42
- GetWorkspace, 2-44
- IsWorkspaceOccupied, 2-55
- reference information, 2-1
- See also procedures
G
- GenerateReplicationSupport procedure, 2-34
- GetConflictWorkspace function, 2-36
- GetDiffVersions function, 2-37
- GetLockMode function, 2-38
- GetMultiWorkspaces, 2-39
- GetOpContext function, 2-40
- GetPrivs function, 2-41
- GetSessionInfo function, 2-42
- GetWorkspace function, 2-44
- GotoWorkspace procedure, 2-48
- grant option, 1-14
- granting
- Workspace Manager privileges
- system, 2-50
- workspace, 2-52
- GrantSystemPriv procedure, 2-50
- GrantWorkspacePriv procedure, 2-52
H
- hierarchy
- removing, 2-75
- workspaces, 1-4
- history option
- EnableVersioning procedure, 2-28
- history views (xxx_HIST), 3-17
I
- implicit savepoints, 1-6
- import considerations, 1-15
- IMPORT_ALLOWED item in WM_INSTALLATION view, 3-14
- installation of Workspace Manager
- with custom databases, A-1
- IsWorkspaceOccupied function, 2-55
L
- LATEST savepoint, 1-6
- LIVE workspace, 1-4
- LOB columns with versioned tables, 2-15
- lock management, 1-12, 1-23
- lock mode
- getting, 2-38
- lock views (xxx_LOCK), 3-17
- locking table rows, 2-56
- LockRows procedure, 2-56
- locks
- disabling, 2-97
- enabling, 2-98
- exclusive, 1-13
- shared, 1-13
- logging of modifications
- EnableVersioning history option, 2-29
- history views (xxx_HIST), 3-17
- long transactions, 1-2
M
- MERGE_ANY_WORKSPACE privilege, 1-14
- MERGE_WORKSPACE privilege, 1-14
- MergeTable procedure, 2-58, 2-69
- MergeWorkspace procedure, 2-61
- merging
- table changes, 2-58
- tables, 2-69
- workspaces, 1-7, 2-61
- messages
- error, D-1
- migrating to another Workspace Manager release, B-1
- multilevel referential integrity constraints, 1-17
- multiworkspace views (xxx_MW), 3-18
N
- nested table
- not supported for EnableVersioning, 2-29
- nonwriter sites, C-1
O
- operation context
- getting, 2-40
P
- parent workspace, 1-4
- conflicts with, 2-93
- privilege management, 1-23
- privileges
- ACCESS_ANY_WORKSPACE, 1-13
- ACCESS_WORKSPACE, 1-13
- CREATE_ANY_WORKSPACE, 1-14
- CREATE_WORKSPACE, 1-13
- description, 1-13
- FREEZE_ANY_WORKSPACE, 1-14
- FREEZE_WORKSPACE, 1-14
- getting, 2-41
- grant option, 1-14
- granting, 2-50, 2-52
- managing, 1-13
- MERGE_ANY_WORKSPACE, 1-14
- MERGE_WORKSPACE, 1-14
- REMOVE_ANY_WORKSPACE, 1-14
- REMOVE_WORKSPACE, 1-14
- revoking, 1-14, 2-80, 2-82
- ROLLBACK_ANY_WORKSPACE, 1-14
- ROLLBACK_WORKSPACE, 1-14
- procedures
- AlterSavepoint, 2-2
- AlterWorkspace, 2-3
- BeginDDL, 2-4
- BeginResolve, 2-6
- CommitDDL, 2-7
- CommitResolve, 2-9
- CompressWorkspace, 2-10
- CompressWorkspaceTree, 2-13
- CopyForUpdate, 2-15
- CreateSavepoint, 2-17
- CreateWorkspace, 2-19
- DeleteSavepoint, 2-22
- DisableVersioning, 2-24
- DropReplicationSupport, 2-27
- EnableVersioning, 2-28
- FreezeWorkspace, 2-31
- GenerateReplicationSupport, 2-34
- GotoWorkspace, 2-48
- GrantSystemPriv, 2-50
- GrantWorkspacePriv, 2-52
- LockRows, 2-56
- MergeTable, 2-58, 2-69
- MergeWorkspace, 2-61
- RecoverAllMigratingTables, 2-63
- RecoverMigratingTable, 2-65
- RefreshTable, 2-67
- RefreshWorkspace, 2-69
- RelocateWriterSite, 2-71
- RemoveWorkspace, 2-73
- RemoveWorkspaceTree, 2-75
- ResolveConflicts, 2-77
- RevokeSystemPriv, 2-80
- RevokeWorkspacePriv, 2-82
- RollbackDDL, 2-84
- RollbackResolve, 2-86
- RollbackTable, 2-87
- RollbackToSP, 2-89
- RollbackWorkspace, 2-91
- SetConflictWorkspace, 2-93
- SetDiffVersions, 2-94
- SetLockingOFF, 2-97
- SetLockingON, 2-98
- SetMultiWorkspaces, 2-100
- SetWoOverwriteOFF, 2-101
- SetWoOverwriteON, 2-103
- SetWorkspaceLockModeOFF, 2-104
- SetWorkspaceLockModeON, 2-105
- SynchronizeSite, 2-107
- UnfreezeWorkspace, 2-108
- UnlockRows, 2-109
- See also functions
R
- RecoverAllMigratingTables procedure, 2-63
- RecoverMigratingTable procedure, 2-65
- referential integrity support, 1-17
- multilevel constraints, 1-17
- refreshing tables, 2-67
- refreshing workspaces, 2-69
- RefreshTable procedure, 2-67
- RefreshWorkspace procedure, 2-69
- RelocateWriterSite procedure, 2-71
- removable savepoints, 1-6
- REMOVE_ANY_WORKSPACE privilege, 1-14
- REMOVE_WORKSPACE privilege, 1-14
- RemoveWorkspace procedure, 2-73
- RemoveWorkspaceTree procedure, 2-75
- removing workspaces, 1-9, 2-73
- replication
- dropping support for, 2-27
- generating support for, 2-34
- relocating writer site, 2-71
- synchronizing local site, 2-107
- using with Workspace Manager, C-1
- WM_REPLICATION_INFO view, 3-14
- writer and nonwriter sites, C-1
- ResolveConflicts procedure, 2-77
- resolving conflicts, 2-77
- beginning, 2-6
- committing, 2-9
- rolling back, 2-86
- RevokeSystemPriv procedure, 2-80
- RevokeWorkspacePriv procedure, 2-82
- revoking privileges, 1-14, 2-80, 2-82
- ROLE_WM_PRIVS view, 3-11
- ROLLBACK_ANY_WORKSPACE privilege, 1-14
- ROLLBACK_WORKSPACE privilege, 1-14
- RollbackDDL procedure, 2-84
- RollbackResolve procedure, 2-86
- RollbackTable procedure, 2-87
- RollbackToSP procedure, 2-89
- RollbackWorkspace procedure, 2-91
- rolling back
- workspace changes, 1-7
- workspaces to savepoint, 2-89
- rolling back tables, 2-87
- rolling back workspaces, 2-91
- rows
- locking, 2-56
- unlocking, 2-109
S
- savepoint management, 1-22
- savepoints, 1-4
- altering description of, 2-2
- as alternative to creating child workspaces, 1-6
- creating, 2-17
- deleting, 2-22
- explicit, 1-5
- implicit, 1-6
- removable, 1-6
- rolling back to, 2-89
- session context, 1-11
- GetSessionInfo function, 2-42
- SetConflictWorkspace procedure, 2-93
- SetDiffVersions procedure, 2-94
- SetLockingON procedure, 2-97, 2-98
- SetMultiWorkspaces procedure, 2-100
- SetWoOverwriteOFF procedure, 2-101
- SetWoOverwriteON procedure, 2-103
- SetWorkspaceLockModeOFF procedure, 2-104
- SetWorkspaceLockModeON procedure, 2-105
- shared locks, 1-13, 2-98
- skeleton tables, 1-15
- SynchronizeSite procedure, 2-107
- synonyms
- support for, 1-19
- system privileges, 2-50
T
- table management, 1-20
- table synonyms, 1-19
- triggers on version-enabled tables, 1-19
U
- UnfreezeWorkspace procedure, 2-108
- unfreezing
- workspaces, 1-8, 2-108
- unlocking
- table rows, 2-109
- UnlockRows procedure, 2-109
- upgrading to another Workspace Manager release, B-1
- USER_WM_LOCKED_TABLES view, 3-11
- USER_WM_MODIFIED_TABLES view, 3-12
- USER_WM_PRIVS view, 3-12
- USER_WM_RIC_INFO view, 3-12
- USER_WM_TAB_TRIGGERS view, 3-12
- USER_WM_VERSIONED_TABLES view, 3-13
- USER_WM_VT_ERRORS view, 3-13
- USER_WORKSPACE_PRIVS view, 3-13
- USER_WORKSPACE_SAVEPOINTS view, 3-13
- USER_WORKSPACES view, 3-13
V
- versioning
- disabling, 2-24
- enabling, 2-28
- VIEW_WO_OVERWRITE mode
- disabling, 2-101
- enabling, 2-103
W
- WM_ADMIN_ROLE role, 1-14
- WM_INSTALLATION view, 3-13
- WM_REPLICATION_INFO view, 3-14
- workspace lock mode
- disabling, 2-104
- enabling, 2-105
- workspaces
- altering description of, 2-3
- child
- as alternative to creating savepoints, 1-6
- compressing, 2-10, 2-13
- continually refreshed, 2-19
- creating, 2-19
- freezing, 1-8, 2-31
- getting, 2-44
- going to, 2-48
- hierarchy, 1-4
- management of, 1-3, 1-21
- merging, 1-7
- rolling back, 1-7
- unfreezing, 1-8, 2-108
- writer site, C-1