PL/SQL Packages DBMS_WM

Database Workspace Manager.
The Oracle database can hold different versions of the same row in one or more workspaces (read-consistent views).
Users of the database can then change these versions independently.

Subprocedures:

AlterSavepoint CreateSavepoint DeleteSavepoint 
AlterWorkspace CreateWorkspace RemoveWorkspace RemoveWorkspaceTree 

BeginResolve 
CommitResolve 

CompressWorkspace
CompressWorkspaceTree
CopyForUpdate 

DisableVersioning 
EnableVersioning 
FreezeWorkspace 

GetConflictWorkspace Function
GetDiffVersions Function
GetLockMode Function
GetMultiWorkspaces Function
GetOpContext Function
GetPrivs Function
GetWorkspace Function

GotoDate 
GotoSavepoint 
GotoWorkspace 

GrantSystemPriv 
GrantWorkspacePriv 

IsWorkspaceOccupied Function
LockRows 
MergeTable 
MergeWorkspace 

RefreshTable 
RefreshWorkspace 

ResolveConflicts 

RevokeSystemPriv 
RevokeWorkspacePriv 

RollbackResolve 
RollbackTable 
RollbackToSP 
RollbackWorkspace 

SetConflictWorkspace 
SetDiffVersions 
SetLockingOFF 
SetLockingON 
SetMultiWorkspaces 
SetWoOverwriteOFF 
SetWoOverwriteON 
SetWorkspaceLockModeOFF 
SetWorkspaceLockModeON 

UnfreezeWorkspace 
UnlockRows  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al



 
Copyright © 1999-2024 SS64.com
Some rights reserved