Index

A B C D E F G H I L M N O P R S T U V W

A

ACCESS_ANY_WORKSPACE privilege, 1-13

ACCESS_WORKSPACE privilege, 1-13

ALL_VERSION_HVIEW view, 3-3

ALL_WM_LOCKED_TABLES view, 3-3

ALL_WM_MODIFIED_TABLES view, 3-3

ALL_WM_RIC_INFO view, 3-4

ALL_WM_TAB_TRIGGERS view, 3-5

ALL_WM_VERSIONED_TABLES view, 3-6

ALL_WM_VT_ERRORS view, 3-7

ALL_WORKSPACE_PRIVS view, 3-8

ALL_WORKSPACE_SAVEPOINTS view, 3-8

ALL_WORKSPACES view, 3-9

altering

savepoint description, 2-2

workspace description, 2-3

AlterSavepoint procedure, 2-2

AlterWorkspace procedure, 2-3

auditing modifications

EnableVersioning history option, 2-29

history views (xxx_HIST), 3-17

auto_commit parameter, 1-10

autocommitting of operations, 1-10

B

BeginDDL procedure, 2-4

BeginResolve procedure, 2-6

C

child workspace, 1-4

as alternative to creating savepoint, 1-6

merging, 2-61, 2-69

refreshing, 2-67, 2-69

removing, 2-75

CommitDDL procedure, 2-7

CommitResolve procedure, 2-9

compressing

workspaces, 2-10, 2-13

CompressWorkspace procedure, 2-10

CompressWorkspaceTree procedure, 2-13

conflict management, 1-24, 2-77

beginning resolution, 2-6

committing resolution, 2-9

rolling back resolution, 2-86

showing conflicts, 2-93

conflict resolution

example, 3-15

conflict views (xxx_CONF), 3-14

context (session), 1-11

GetSessionInfo function, 2-42

context of current operation

getting, 2-40

continually refreshed workspaces, 2-19

CopyForUpdate procedure, 2-15

CREATE_ANY_WORKSPACE privilege, 1-14

CREATE_WORKSPACE privilege, 1-13

CreateSavepoint procedure, 2-17

CreateWorkspace procedure, 2-19

creating

savepoints, 2-17

workspaces, 2-19

custom databases

installation of Workspace Manager required, A-1

D

Database Configuration Assistant (DBCA)

no separate Workspace Manager installation required, A-1

DBA_WORKSPACE_SESSIONS view, 3-11

DBMS_WM public synonym, 2-1

DDL (data definition language) operations

beginning, 2-4

committing, 2-7

requirements and restrictions, 1-15

rolling back, 2-84

DeleteSavepoint procedure, 2-22

deleting

savepoints, 2-22

workspace, 1-9, 2-73

difference views (xxx_DIFF), 3-15

DisableVersioning procedure, 2-24

disabling

workspace changes, 2-31

downgrading to another Workspace Manager release, B-1

DropReplicationSupport procedure, 2-27

E

EnableVersioning procedure, 2-28

error messages, D-1

example

conflict resolution, 3-15

using Workspace Manager (many operations), 1-25

exclusive locks, 1-13, 2-98

explicit savepoints, 1-5

export considerations, 1-15

F

foreign keys with version-enabled tables, 1-17

FREEZE_ANY_WORKSPACE privilege, 1-14

FREEZE_WORKSPACE privilege, 1-14

FreezeWorkspace procedure, 2-31

freezing

workspace changes, 1-8, 2-31

functions

GetConflictWorkspace, 2-36

GetDiffVersions, 2-37

GetLockMode, 2-38

GetMultiWorkspaces, 2-39

GetOpContext, 2-40

GetPrivs, 2-41

GetSessionInfo, 2-42

GetWorkspace, 2-44

IsWorkspaceOccupied, 2-55

reference information, 2-1

See also procedures

G

GenerateReplicationSupport procedure, 2-34

GetConflictWorkspace function, 2-36

GetDiffVersions function, 2-37

GetLockMode function, 2-38

GetMultiWorkspaces, 2-39

GetOpContext function, 2-40

GetPrivs function, 2-41

GetSessionInfo function, 2-42

GetWorkspace function, 2-44

GotoWorkspace procedure, 2-48

grant option, 1-14

granting

Workspace Manager privileges

system, 2-50

workspace, 2-52

GrantSystemPriv procedure, 2-50

GrantWorkspacePriv procedure, 2-52

H

hierarchy

removing, 2-75

workspaces, 1-4

history option

EnableVersioning procedure, 2-28

history views (xxx_HIST), 3-17

I

implicit savepoints, 1-6

import considerations, 1-15

IMPORT_ALLOWED item in WM_INSTALLATION view, 3-14

installation of Workspace Manager

with custom databases, A-1

IsWorkspaceOccupied function, 2-55

L

LATEST savepoint, 1-6

LIVE workspace, 1-4

LOB columns with versioned tables, 2-15

lock management, 1-12, 1-23

lock mode

getting, 2-38

lock views (xxx_LOCK), 3-17

locking table rows, 2-56

LockRows procedure, 2-56

locks

disabling, 2-97

enabling, 2-98

exclusive, 1-13

shared, 1-13

logging of modifications

EnableVersioning history option, 2-29

history views (xxx_HIST), 3-17

long transactions, 1-2

M

MERGE_ANY_WORKSPACE privilege, 1-14

MERGE_WORKSPACE privilege, 1-14

MergeTable procedure, 2-58, 2-69

MergeWorkspace procedure, 2-61

merging

table changes, 2-58

tables, 2-69

workspaces, 1-7, 2-61

messages

error, D-1

migrating to another Workspace Manager release, B-1

multilevel referential integrity constraints, 1-17

multiworkspace views (xxx_MW), 3-18

N

nested table

not supported for EnableVersioning, 2-29

nonwriter sites, C-1

O

operation context

getting, 2-40

P

parent workspace, 1-4

conflicts with, 2-93

privilege management, 1-23

privileges

ACCESS_ANY_WORKSPACE, 1-13

ACCESS_WORKSPACE, 1-13

CREATE_ANY_WORKSPACE, 1-14

CREATE_WORKSPACE, 1-13

description, 1-13

FREEZE_ANY_WORKSPACE, 1-14

FREEZE_WORKSPACE, 1-14

getting, 2-41

grant option, 1-14

granting, 2-50, 2-52

managing, 1-13

MERGE_ANY_WORKSPACE, 1-14

MERGE_WORKSPACE, 1-14

REMOVE_ANY_WORKSPACE, 1-14

REMOVE_WORKSPACE, 1-14

revoking, 1-14, 2-80, 2-82

ROLLBACK_ANY_WORKSPACE, 1-14

ROLLBACK_WORKSPACE, 1-14

procedures

AlterSavepoint, 2-2

AlterWorkspace, 2-3

BeginDDL, 2-4

BeginResolve, 2-6

CommitDDL, 2-7

CommitResolve, 2-9

CompressWorkspace, 2-10

CompressWorkspaceTree, 2-13

CopyForUpdate, 2-15

CreateSavepoint, 2-17

CreateWorkspace, 2-19

DeleteSavepoint, 2-22

DisableVersioning, 2-24

DropReplicationSupport, 2-27

EnableVersioning, 2-28

FreezeWorkspace, 2-31

GenerateReplicationSupport, 2-34

GotoWorkspace, 2-48

GrantSystemPriv, 2-50

GrantWorkspacePriv, 2-52

LockRows, 2-56

MergeTable, 2-58, 2-69

MergeWorkspace, 2-61

RecoverAllMigratingTables, 2-63

RecoverMigratingTable, 2-65

RefreshTable, 2-67

RefreshWorkspace, 2-69

RelocateWriterSite, 2-71

RemoveWorkspace, 2-73

RemoveWorkspaceTree, 2-75

ResolveConflicts, 2-77

RevokeSystemPriv, 2-80

RevokeWorkspacePriv, 2-82

RollbackDDL, 2-84

RollbackResolve, 2-86

RollbackTable, 2-87

RollbackToSP, 2-89

RollbackWorkspace, 2-91

SetConflictWorkspace, 2-93

SetDiffVersions, 2-94

SetLockingOFF, 2-97

SetLockingON, 2-98

SetMultiWorkspaces, 2-100

SetWoOverwriteOFF, 2-101

SetWoOverwriteON, 2-103

SetWorkspaceLockModeOFF, 2-104

SetWorkspaceLockModeON, 2-105

SynchronizeSite, 2-107

UnfreezeWorkspace, 2-108

UnlockRows, 2-109

See also functions

R

RecoverAllMigratingTables procedure, 2-63

RecoverMigratingTable procedure, 2-65

referential integrity support, 1-17

multilevel constraints, 1-17

refreshing tables, 2-67

refreshing workspaces, 2-69

RefreshTable procedure, 2-67

RefreshWorkspace procedure, 2-69

RelocateWriterSite procedure, 2-71

removable savepoints, 1-6

REMOVE_ANY_WORKSPACE privilege, 1-14

REMOVE_WORKSPACE privilege, 1-14

RemoveWorkspace procedure, 2-73

RemoveWorkspaceTree procedure, 2-75

removing workspaces, 1-9, 2-73

replication

dropping support for, 2-27

generating support for, 2-34

relocating writer site, 2-71

synchronizing local site, 2-107

using with Workspace Manager, C-1

WM_REPLICATION_INFO view, 3-14

writer and nonwriter sites, C-1

ResolveConflicts procedure, 2-77

resolving conflicts, 2-77

beginning, 2-6

committing, 2-9

rolling back, 2-86

RevokeSystemPriv procedure, 2-80

RevokeWorkspacePriv procedure, 2-82

revoking privileges, 1-14, 2-80, 2-82

ROLE_WM_PRIVS view, 3-11

ROLLBACK_ANY_WORKSPACE privilege, 1-14

ROLLBACK_WORKSPACE privilege, 1-14

RollbackDDL procedure, 2-84

RollbackResolve procedure, 2-86

RollbackTable procedure, 2-87

RollbackToSP procedure, 2-89

RollbackWorkspace procedure, 2-91

rolling back

workspace changes, 1-7

workspaces to savepoint, 2-89

rolling back tables, 2-87

rolling back workspaces, 2-91

rows

locking, 2-56

unlocking, 2-109

S

savepoint management, 1-22

savepoints, 1-4

altering description of, 2-2

as alternative to creating child workspaces, 1-6

creating, 2-17

deleting, 2-22

explicit, 1-5

implicit, 1-6

removable, 1-6

rolling back to, 2-89

session context, 1-11

GetSessionInfo function, 2-42

SetConflictWorkspace procedure, 2-93

SetDiffVersions procedure, 2-94

SetLockingON procedure, 2-97, 2-98

SetMultiWorkspaces procedure, 2-100

SetWoOverwriteOFF procedure, 2-101

SetWoOverwriteON procedure, 2-103

SetWorkspaceLockModeOFF procedure, 2-104

SetWorkspaceLockModeON procedure, 2-105

shared locks, 1-13, 2-98

skeleton tables, 1-15

SynchronizeSite procedure, 2-107

synonyms

support for, 1-19

system privileges, 2-50

T

table management, 1-20

table synonyms, 1-19

triggers on version-enabled tables, 1-19

U

UnfreezeWorkspace procedure, 2-108

unfreezing

workspaces, 1-8, 2-108

unlocking

table rows, 2-109

UnlockRows procedure, 2-109

upgrading to another Workspace Manager release, B-1

USER_WM_LOCKED_TABLES view, 3-11

USER_WM_MODIFIED_TABLES view, 3-12

USER_WM_PRIVS view, 3-12

USER_WM_RIC_INFO view, 3-12

USER_WM_TAB_TRIGGERS view, 3-12

USER_WM_VERSIONED_TABLES view, 3-13

USER_WM_VT_ERRORS view, 3-13

USER_WORKSPACE_PRIVS view, 3-13

USER_WORKSPACE_SAVEPOINTS view, 3-13

USER_WORKSPACES view, 3-13

V

versioning

disabling, 2-24

enabling, 2-28

VIEW_WO_OVERWRITE mode

disabling, 2-101

enabling, 2-103

W

WM_ADMIN_ROLE role, 1-14

WM_INSTALLATION view, 3-13

WM_REPLICATION_INFO view, 3-14

workspace lock mode

disabling, 2-104

enabling, 2-105

workspaces

altering description of, 2-3

child

as alternative to creating savepoints, 1-6

compressing, 2-10, 2-13

continually refreshed, 2-19

creating, 2-19

freezing, 1-8, 2-31

getting, 2-44

going to, 2-48

hierarchy, 1-4

management of, 1-3, 1-21

merging, 1-7

rolling back, 1-7

unfreezing, 1-8, 2-108

writer site, C-1