Skip Headers
Oracle® Database Workspace Manager Developer's Guide
11g Release 2 (11.2)

Part Number E11826-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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_RIC_INFO view, 5.11
ALL_WM_TAB_TRIGGERS view, 5.12
ALL_WM_VERSIONED_TABLES view, 5.13
ALL_WM_VT_ERRORS view, 5.14
ALL_WORKSPACE_PRIVS view, 5.15
ALL_WORKSPACE_SAVEPOINTS view, 5.16
ALL_WORKSPACES view, 5.17
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.51
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.44
WM_COMPRESSIBLE_TABLES view, 5.45
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.49
conflict views (xxx_CONF), 5.49
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.18
DBA_WM_SYS_PRIVS view, 5.19
DBA_WM_VERSIONED_TABLES view, 5.20
DBA_WM_VT_ERRORS view, 5.21
DBA_WORKSPACE_PRIVS view, 5.22
DBA_WORKSPACE_SAVEPOINTS view, 5.23
DBA_WORKSPACE_SESSIONS view, 5.24
DBA_WORKSPACES view, 5.25
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
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
GotoDate, 4
GotoSavepoint, 4
GotoWorkspace, 4
GrantGraphPriv, 4
GrantPrivsOnPolicy, 4
GrantSystemPriv, 4
GrantWorkspacePriv, 4
Import, 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.50
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.46
example
conflict resolution, 5.49
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
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

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.51

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

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.52
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.51
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.53

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.47

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
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.19
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.48
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.26
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.47
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.19

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.27
USER_MP_PARENT_WORKSPACES view, 5.28
USER_REMOVED_WORKSPACES view, 5.29
USER_WM_CONS_COLUMNS view, 5.30
USER_WM_CONSTRAINTS view, 5.31
USER_WM_IND_COLUMNS view, 5.32
USER_WM_IND_EXPRESSIONS view, 5.33
USER_WM_LOCKED_TABLES view, 5.34
USER_WM_MODIFIED_TABLES view, 5.35
USER_WM_PRIVS view, 5.36
USER_WM_RIC_INFO view, 5.37
USER_WM_TAB_TRIGGERS view, 5.38
USER_WM_VERSIONED_TABLES view, 5.39
USER_WM_VT_ERRORS view, 5.40
USER_WORKSPACE_PRIVS view, 5.41
USER_WORKSPACE_SAVEPOINTS view, 5.42
USER_WORKSPACES view, 5.43
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.47
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.44
WM_COMPRESSIBLE_TABLES view, 5.45
WM_CONTAINS operator, 3.5.1
WM_EQUALS operator, 3.5.2
WM_EVENTS_INFO view, 5.46
WM_GREATERTHAN operator, 3.5.3
WM_INSTALLATION view, 5.47
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.48
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