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