Oracle sample schemas (continued)
Workspace Manager example, 1-52
OWM_VERSION
Workspace Manager version number, 5-24
P
parent row, 1-8
parent workspace, 1-5
conflicts with, 4-117
partitioned index
cannot be created or dropped on version-
enabled table, 1-36
physical table name
and Workspace Manager infrastructure, 1-12
getting, 4-60
privilege management, 1-47
privileges
description, 1-24
getting, 4-61
grant option, 1-25
granted to PUBLIC user group, 1-15
granting, 4-72, 4-73
multiparent graph workspaces, 4-69
OLS-related, 4-71
managing, 1-24
revoking, 1-25, 4-106, 4-107
multiparent graph workspaces, 4-104
viewing users having Workspace Manager
system-level privileges, 5-17
PurgeTable procedure, 4-88
R
RecoverAllMigratingTables procedure, 4-90
RecoverFromDroppedUser procedure, 4-91
RecoverMigratingTable procedure, 4-92
referential integrity constraints
finding affected tables, 4-51
lock management with DML operations, 1-39
referential integrity support, 1-37
multilevel constraints, 1-37
refreshing
tables, 4-93
workspaces, 4-94
RefreshTable procedure, 4-93
RefreshWorkspace procedure, 4-94
removable savepoints, 1-6
RemoveAsParentWorkspace procedure, 4-96
RemoveDeferredWorkspaces procedure, 4-97
RemoveUserDefinedHint procedure, 4-98
RemoveWorkspace procedure, 4-98
RemoveWorkspaceTree procedure, 4-100
removing deferred workspaces, 4-97
removing workspaces, 1-9, 4-98
RenameSavepoint procedure, 4-101
RenameWorkspace procedure, 4-101
renaming
savepoint, 4-101
workspace, 4-101
reserved words and characters with Workspace
Manager, 1-43
ResolveConflicts procedure, 4-102
resolving conflicts, 4-102
beginning, 4-16
committing, 4-23
rolling back, 4-110
RETURNING clause
not supported for INSERT or UPDATE on
version-enabled tables, 1-13
reverse index
supported on version-enabled table, 1-36
RevokeGraphPriv procedure, 4-104
RevokeSystemPriv procedure, 4-106
RevokeWorkspacePriv procedure, 4-107
revoking privileges, 1-25, 4-106, 4-107
multiparent graph workspaces, 4-104
ROLE_WM_PRIVS view, 5-20
RollbackBulkLoading procedure, 4-108
RollbackDDL procedure, 4-109
RollbackResolve procedure, 4-110
RollbackTable procedure, 4-111
RollbackToSP procedure, 4-112
RollbackWorkspace procedure, 4-113
rolling back
changes in a table, 4-111
workspace changes, 1-7, 4-113
workspaces to savepoint, 4-112
row versions
creation of, 1-13
row-level security (VPD)
Workspace Manager considerations, 1-41
rows
locking, 4-81
unlocking, 4-133
rule-based subscription for Workspace Manager
events, 2-5
S
sample schemas
Workspace Manager example, 1-52
savepoint management, 1-46
savepoints, 1-3
altering description of, 4-8
as alternative to creating child workspaces,
1-6
creating, 4-33
deleting, 4-37
explicit, 1-5
Index
5