Oracle 9i. Application Developer’s Guide – Workspace Manager

Murray C.

OracIe 9i Application Developer’s Guide – Workspace Manager is intended for application designers and developers who want to use Oracle Database Workspace Manager, often referred to as Workspace Manager, to work with long transactions. It is assumed that you have some experience programming in PL/SQL.

---

Table of contents :
Application Developer’s Guide – Workspace Manager……Page 1
List of Examples……Page 7
List of Figures……Page 8
List of Tables……Page 9
Send Us Your Comments……Page 11
Preface……Page 13
1 Introduction……Page 17
1.1 Workspace Management……Page 18
1.2.1 Hierarchy of Workspaces……Page 19
1.2.2 Using Savepoints……Page 20
1.2.3 Merging and Rolling Back Workspace Changes……Page 21
1.2.4 Autocommitting of Workspace Manager Operations……Page 22
1.2.6 Freezing and Unfreezing Workspaces……Page 23
1.3 Lock Management……Page 24
1.4 Privilege Management……Page 25
1.6 Referential Integrity Support……Page 27
1.7 Triggers on Version-Enabled Tables……Page 28
1.8.2 Workspace Management……Page 29
1.8.3 Savepoint Management……Page 30
1.8.5 Lock Management……Page 31
1.8.6 Conflict Management……Page 32
1.9 Simplified Example……Page 33
2 Procedures: Reference……Page 39
AlterSavepoint……Page 40
AlterWorkspace……Page 41
BeginResolve……Page 42
CommitResolve……Page 43
CompressWorkspace……Page 44
CompressWorkspaceTree……Page 47
CopyForUpdate……Page 49
CreateSavepoint……Page 51
CreateWorkspace……Page 53
DeleteSavepoint……Page 55
DisableVersioning……Page 57
EnableVersioning……Page 59
FreezeWorkspace……Page 61
GetConflictWorkspace……Page 63
GetDiffVersions……Page 64
GetLockMode……Page 65
GetMultiWorkspaces……Page 66
GetOpContext……Page 67
GetPrivs……Page 68
GetWorkspace……Page 69
GotoDate……Page 70
GotoSavepoint……Page 72
GotoWorkspace……Page 73
GrantSystemPriv……Page 75
GrantWorkspacePriv……Page 77
IsWorkspaceOccupied……Page 80
LockRows……Page 81
MergeTable……Page 83
MergeWorkspace……Page 86
RefreshTable……Page 88
RefreshWorkspace……Page 90
RemoveWorkspace……Page 92
RemoveWorkspaceTree……Page 94
ResolveConflicts……Page 96
RevokeSystemPriv……Page 99
RevokeWorkspacePriv……Page 101
RollbackResolve……Page 103
RollbackTable……Page 104
RollbackToSP……Page 106
RollbackWorkspace……Page 108
SetConflictWorkspace……Page 110
SetDiffVersions……Page 111
SetLockingOFF……Page 113
SetLockingON……Page 114
SetMultiWorkspaces……Page 116
SetWoOverwriteOFF……Page 118
SetWoOverwriteON……Page 120
SetWorkspaceLockModeOFF……Page 121
SetWorkspaceLockModeON……Page 122
UnfreezeWorkspace……Page 124
UnlockRows……Page 125
3 Metadata Views……Page 127
3.1 ALL_VERSION_HVIEW……Page 128
3.3 ALL_WM_MODIFIED_TABLES……Page 129
3.5 ALL_WM_TAB_TRIGGERS……Page 130
3.7 ALL_WORKSPACE_PRIVS……Page 132
3.9 ALL_WORKSPACES……Page 133
3.10 DBA_WORKSPACE_SESSIONS……Page 134
3.12 USER_WM_LOCKED_TABLES……Page 135
3.16 USER_WM_TAB_TRIGGERS……Page 136
3.21 xxx_CONF Views……Page 137
3.22 xxx_DIFF Views……Page 138
3.24 xxx_HIST Views……Page 140
3.25 xxx_MW Views……Page 141
A Installing Workspace Manager with Custom Databases……Page 143
B Error Messages……Page 145
Glossary……Page 177
Index……Page 181