Index

A  B  C  D  E  F  G  H  I  J  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

AddAsParentWorkspace procedure, 4

Advanced Queueing

and Workspace Manager events, 2

ALL_MP_GRAPH_WORKSPACES view, 5.1

ALL_MP_PARENT_WORKSPACES view, 5.2

ALL_VERSION_HVIEW view, 5.3

ALL_WM_CONS_COLUMNS view, 5.4

ALL_WM_CONSTRAINTS view, 5.5

ALL_WM_IND_COLUMNS view, 5.6

ALL_WM_IND_EXPRESSIONS view, 5.7

ALL_WM_LOCKED_TABLES view, 5.8

ALL_WM_MODIFIED_TABLES view, 5.9

ALL_WM_RIC_INFO view, 5.10

ALL_WM_TAB_TRIGGERS view, 5.11

ALL_WM_VERSIONED_TABLES view, 5.12

ALL_WM_VT_ERRORS view, 5.13

ALL_WORKSPACE_PRIVS view, 5.14

ALL_WORKSPACE_SAVEPOINTS view, 5.15

ALL_WORKSPACES view, 5.16

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

auto_commit parameter, 1.1.8

autocommitting of operations, 1.1.8

---

B

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

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

WM_COMPRESSIBLE_TABLES view, 5.38

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

conflict views (xxx_CONF), 5.42

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_WM_SYS_PRIVS view, 5.17

DBA_WM_VT_ERRORS view, 5.18

DBA_WORKSPACE_SESSIONS view, 5.19

DBMS_WM package, 1.1.12

Add_Topo_Geometry_Layer, 4

AddAsParentWorkspace, 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

GotoWorkspace, 4

GrantGraphPriv, 4

GrantSystemPriv, 4

GrantWorkspacePriv, 4

Import, 4

IsWorkspaceOccupied, 4

LockRows, 4

MergeTable, 4

MergeWorkspace, 4

Move_Proc, 4

RecoverAllMigratingTables, 4

RecoverFromDroppedUser, 4

RecoverMigratingTable, 4

RefreshTable, 4

RefreshWorkspace, 4

RelocateWriterSite, 4

RemoveAsParentWorkspace, 4

RemoveWorkspace, 4

RemoveWorkspaceTree, 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

SetWMValidTimeFilterOFF, 4

SetWMValidTimeFilterON, 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.43

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

example

conflict resolution, 5.42

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

GotoWorkspace procedure, 4

grant option, 1.4

GrantGraphPriv procedure, 4

granting

Workspace Manager privileges

multiparent graph workspaces, 4

system, 4

workspace, 4

GrantSystemPriv procedure, 4

GrantWorkspacePriv procedure, 4

---

H

hierarchy

removing, 4

workspaces, 1.1.1

history columns

upgrading, B.3

history management changes for release 10.1, B.3

history option

EnableVersioning procedure, 4

history views (xxx_HIST), 5.44

---

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

---

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

lock mode

getting, 4

lock views (xxx_LOCK), 5.45

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

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

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

---

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

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 sample schemas

Workspace Manager example, 1.17.2

OWM_VERSION

Workspace Manager version number, 5.40

---

P

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

granting, 4, 4

multiparent graph workspaces, 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.17

---

R

RecoverAllMigratingTables procedure, 4

RecoverFromDroppedUser procedure, 4

RecoverMigratingTable procedure, 4

referential integrity constraints

finding affected tables, 4

referential integrity support, 1.9.1

multilevel constraints, 1.9.1

refreshing

workspaces, 4

refreshing tables, 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

RemoveWorkspace procedure, 4

RemoveWorkspaceTree procedure, 4

removing workspaces, 1.1.6, 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.41

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

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

implicit, 1.1.2

removable, 1.1.2

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

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

SetWMValidTimeFilterOFF procedure, 4

SetWMValidTimeFilterON 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

SYS.OWM_PKG.UpgradeHistoryColumns procedure, B.3

system parameters

ALLOW_CAPTURE_EVENTS, 1.5

ALLOW_MULTI_PARENT_WORKSPACES, 1.5

ALLOW_NESTED_TABLE_COLUMNS, 1.5

CR_WORKSPACE_MODE, 1.5

FIRE_TRIGGERS_FOR_NONDML_EVENTS, 1.5

for Workspace Manager, 1.5

NONCR_WORKSPACE_MODE, 1.5

NUMBER_OF_COMPRESS_BATCHES, 1.5

shown in WM_INSTALLATION view, 5.40

UNDO_SPACE, 1.5

USE_TIMESTAMP_TYPE_FOR_HISTORY, 1.5

system privileges, 4

viewing users having Workspace Manager system-level privileges, 5.17

---

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

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_TIMESTAMP_TYPE_FOR_HISTORY system parameter, 1.5

UseDefaultValuesForNulls procedure, 4

USER_MP_GRAPH_WORKSPACES view, 5.21

USER_MP_PARENT_WORKSPACES view, 5.22

USER_WM_CONS_COLUMNS view, 5.23

USER_WM_CONSTRAINTS view, 5.24

USER_WM_IND_COLUMNS view, 5.25

USER_WM_IND_EXPRESSIONS view, 5.26

USER_WM_LOCKED_TABLES view, 5.27

USER_WM_MODIFIED_TABLES view, 5.28

USER_WM_PRIVS view, 5.29

USER_WM_RIC_INFO view, 5.30

USER_WM_TAB_TRIGGERS view, 5.31

USER_WM_VERSIONED_TABLES view, 5.32

USER_WM_VT_ERRORS view, 5.33

USER_WORKSPACE_PRIVS view, 5.34

USER_WORKSPACE_SAVEPOINTS view, 5.35

USER_WORKSPACES view, 5.36

---

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

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

WM_COMPRESSIBLE_TABLES view, 5.38

WM_CONTAINS operator, 3.5.1

WM_EQUALS operator, 3.5.2

WM_EVENTS_INFO view, 5.39

WM_GREATERTHAN operator, 3.5.3

WM_INSTALLATION view, 5.40

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

WMSYS schema and user, 1.1.12

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

rolling back, 1.1.3

unfreezing, 1.1.5, 4

writer site, C