Index

A  B  C  D  E  F  G  H  I  J  K  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
ADD_UNIQUE_COLUMN_TO_HISTORY_VIEW system parameter, 1.5
AddAsParentWorkspace procedure, 4
AddUserDefinedHint procedure, 4
Advanced Queuing
and Workspace Manager events, 2
ALL_MP_GRAPH_WORKSPACES view, 5.1
ALL_MP_PARENT_WORKSPACES view, 5.2
ALL_REMOVED_WORKSPACES view, 5.3
ALL_VERSION_HVIEW view, 5.4
ALL_WM_CONS_COLUMNS view, 5.5
ALL_WM_CONSTRAINTS view, 5.6
ALL_WM_IND_COLUMNS view, 5.7
ALL_WM_IND_EXPRESSIONS view, 5.8
ALL_WM_LOCKED_TABLES view, 5.9
ALL_WM_MODIFIED_TABLES view, 5.10
ALL_WM_POLICIES view, 5.11
ALL_WM_RIC_INFO view, 5.12
ALL_WM_TAB_TRIGGERS view, 5.13
ALL_WM_VERSIONED_TABLES view, 5.14
ALL_WM_VT_ERRORS view, 5.15
ALL_WORKSPACE_PRIVS view, 5.16
ALL_WORKSPACE_SAVEPOINTS view, 5.17
ALL_WORKSPACES view, 5.18
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.53
auto_commit parameter, 1.1.8
autocommitting of operations, 1.1.8

B

base row, 1.1.4
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 row, 1.1.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
COMPRESS_PARENT_WORKSPACE_AFTER_REMOVE system parameter, 1.5
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.46
WM_COMPRESSIBLE_TABLES view, 5.47
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.51
conflict views (xxx_CONF), 5.51
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_REMOVED_WORKSPACES view, 5.19
DBA_WM_SYS_PRIVS view, 5.20
DBA_WM_VERSIONED_TABLES view, 5.21
DBA_WM_VT_ERRORS view, 5.22
DBA_WORKSPACE_PRIVS view, 5.23
DBA_WORKSPACE_SAVEPOINTS view, 5.24
DBA_WORKSPACE_SESSIONS view, 5.25
DBA_WORKSPACES view, 5.26
DBMS_WM package, 1.1.13
Add_Topo_Geometry_Layer, 4
AddAsParentWorkspace, 4
AddUserDefinedHint, 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
Export_Schemas, 4
FindRICSet, 4
FreezeWorkspace, 4
GenerateReplicationSupport, 4
GetBulkLoadVersion, 4
GetConflictWorkspace, 4
GetDiffVersions, 4
GetLockMode, 4
GetMultiWorkspaces, 4
GetOpContext, 4
GetOriginalDDL, 4
GetPhysicalTableName, 4
GetPrivs, 4
GetSessionInfo, 4
GetSystemParameter, 4
GetValidFrom, 4
GetValidTill, 4
GetWMMetadataSpace, 4
GetWorkspace, 4
GotoDate, 4
GotoSavepoint, 4
GotoWorkspace, 4
GrantGraphPriv, 4
GrantPrivsOnPolicy, 4
GrantSystemPriv, 4
GrantWorkspacePriv, 4
Import, 4
Import_Schemas, 4
IsWorkspaceOccupied, 4
LockRows, 4
MergeTable, 4
MergeWorkspace, 4
Move_Proc, 4
PurgeTable, 4
RecoverAllMigratingTables, 4
RecoverFromDroppedUser, 4
RecoverMigratingTable, 4
RefreshTable, 4
RefreshWorkspace, 4
RelocateWriterSite, 4
RemoveAsParentWorkspace, 4
RemoveUserDefinedHint, 4
RemoveWorkspace, 4
RemoveWorkspaceTree, 4
RenameSavepoint, 4
RenameWorkspace, 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
SetValidTimeFilterOFF, 4
SetValidTimeFilterON, 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.52
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.48
example
conflict resolution, 5.51
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
Export_Schemas 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
GetOriginalDDL procedure, 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
GotoDate procedure, 4
GotoSavepoint procedure, 4
GotoWorkspace procedure, 4
grant option, 1.4
GrantGraphPriv procedure, 4
granting
Workspace Manager privileges
multiparent graph workspaces, 4
OLS-related, 4
system, 4
workspace, 4
GrantPrivsOnPolicy procedure, 4
GrantSystemPriv procedure, 4
GrantWorkspacePriv procedure, 4
GRAPTPRIV_ANY_WORKSPACE privilege, 1.4
GRAPTPRIV_WORKSPACE privilege, 1.4

H

hierarchy
removing, 4
workspaces, 1.1.1
historical data, 1.1.12
history columns
upgrading, B.3
history management changes for release 10.1, B.3
history option
EnableVersioning procedure, 4
history views (xxx_HIST), 5.53

I

implicit savepoints, 1.1.2
import considerations, 1.6
Import procedure, 4
Import_Schemas 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

K

KEEP_REMOVED_WORKSPACES_INFO system parameter, 1.5

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
with DML operations on tables with referential integrity constraints, 1.9.1.1
lock mode
getting, 4
lock views (xxx_LOCK), 5.54
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.53
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
memory
TARGET_PGA_MEMORY system parameter, 1.5
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.55

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
OLS (Oracle Label Security)
DDL operations on version-enabled tables, 1.8
granting privileges related t, 4
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 Label Security (OLS)
DDL operations on version-enabled tables, 1.8
granting privileges related to, 4
Oracle sample schemas
Workspace Manager example, 1.17.2
OWM_VERSION
Workspace Manager version number, 5.49

P

parent row, 1.1.4
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.13
granting, 4, 4
multiparent graph workspaces, 4
OLS-related, 4
GRANTPRIV_ANY_WORKSPACE, 1.4
GRANTPRIV_WORKSPACE, 1.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.20
WM_ADMIN, 1.4
PurgeTable procedure, 4

R

RecoverAllMigratingTables procedure, 4
RecoverFromDroppedUser procedure, 4
RecoverMigratingTable procedure, 4
referential integrity constraints
finding affected tables, 4
lock management with DML operations, 1.9.1.1
referential integrity support, 1.9.1
multilevel constraints, 1.9.1
refreshing
tables, 4
workspaces, 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
RemoveUserDefinedHint procedure, 4
RemoveWorkspace procedure, 4
RemoveWorkspaceTree procedure, 4
removing workspaces, 1.1.6, 4
RenameSavepoint procedure, 4
RenameWorkspace procedure, 4
renaming
savepoint, 4
workspace, 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.50
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.27
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 versions
creation of, 1.1.12
ROW_LEVEL_LOCKING system parameter, 1.5
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
going to, 4
implicit, 1.1.2
removable, 1.1.2
renaming, 4
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
SET NULL constraints
not supported for version-enabled tables, 1.9.3
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
SetValidTimeFilterOFF procedure, 4
SetValidTimeFilterON 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
system parameters
ADD_UNIQUE_COLUMN_TO_HISTORY_VIEW, 1.5
ALLOW_CAPTURE_EVENTS, 1.5
ALLOW_MULTI_PARENT_WORKSPACES, 1.5
ALLOW_NESTED_TABLE_COLUMNS, 1.5
COMPRESS_PARENT_WORKSPACE_AFTER_REMOVE, 1.5
CR_WORKSPACE_MODE, 1.5
FIRE_TRIGGERS_FOR_NONDML_EVENTS, 1.5
for Workspace Manager, 1.5
KEEP_REMOVED_WORKSPACES_INFO, 1.5
NONCR_WORKSPACE_MODE, 1.5
NUMBER_OF_COMPRESS_BATCHES, 1.5
ROW_LEVEL_LOCKING, 1.5
shown in WM_INSTALLATION view, 5.49
TARGET_PGA_MEMORY, 1.5
UNDO_SPACE, 1.5
USE_SCALAR_TYPES_FOR_VALIDTIME, 1.5
USE_TIMESTAMP_TYPE_FOR_HISTORY, 1.5
system privileges, 4
viewing users having Workspace Manager system-level privileges, 5.20

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
TARGET_PGA_MEMORY system parameter, 1.5
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_SCALAR_TYPES_FOR_VALIDTIME system parameter, 1.5
USE_TIMESTAMP_TYPE_FOR_HISTORY system parameter, 1.5
UseDefaultValuesForNulls procedure, 4
USER_MP_GRAPH_WORKSPACES view, 5.28
USER_MP_PARENT_WORKSPACES view, 5.29
USER_REMOVED_WORKSPACES view, 5.30
USER_WM_CONS_COLUMNS view, 5.31
USER_WM_CONSTRAINTS view, 5.32
USER_WM_IND_COLUMNS view, 5.33
USER_WM_IND_EXPRESSIONS view, 5.34
USER_WM_LOCKED_TABLES view, 5.35
USER_WM_MODIFIED_TABLES view, 5.36
USER_WM_POLICIES view, 5.37
USER_WM_PRIVS view, 5.38
USER_WM_RIC_INFO view, 5.39
USER_WM_TAB_TRIGGERS view, 5.40
USER_WM_VERSIONED_TABLES view, 5.41
USER_WM_VT_ERRORS view, 5.42
USER_WORKSPACE_PRIVS view, 5.43
USER_WORKSPACE_SAVEPOINTS view, 5.44
USER_WORKSPACES view, 5.45
user-defined hints
adding, 4
removing, 4

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.49
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 privilege, 1.4
WM_ADMIN_ROLE role, 1.4
WM_COMPRESS_BATCH_SIZES view, 5.46
WM_COMPRESSIBLE_TABLES view, 5.47
WM_CONTAINS operator, 3.5.1
WM_EQUALS operator, 3.5.2
WM_EVENTS_INFO view, 5.48
WM_GREATERTHAN operator, 3.5.3
WM_INSTALLATION view, 5.49
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.50
WMSYS schema and user, 1.1.13
WMSYS.OWM_PKG.UpgradeHistoryColumns procedure, B.3
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
renaming, 4
rolling back, 1.1.3
unfreezing, 1.1.5, 4
writer site, C