Oracle9
i
Application Developer's Guide - Workspace Manager
Release 1 (9.0.1)
Part Number A88806-01
Home
Book List
Index
Master Index
Feedback
Contents
Title and Copyright Information
List of Examples
List of Figures
List of Tables
Send Us Your Comments
Preface
1 Introduction
1.1 Workspace Management
1.2 Workspace Concepts and Operations
1.2.1 Hierarchy of Workspaces
1.2.2 Using Savepoints
1.2.3 Merging and Rolling Back Workspace Changes
1.2.4 Autocommitting of Workspace Manager Operations
1.2.5 Resolving Conflicts
1.2.6 Freezing and Unfreezing Workspaces
1.2.7 Removing Workspaces
1.3 Lock Management
1.4 Privilege Management
1.5 Import and Export Considerations
1.6 Referential Integrity Support
1.7 Triggers on Version-Enabled Tables
1.8 Procedure Categories
1.8.1 Table Management
1.8.2 Workspace Management
1.8.3 Savepoint Management
1.8.4 Privilege Management
1.8.5 Lock Management
1.8.6 Conflict Management
1.9 Simplified Example
2 Procedures: Reference
AlterSavepoint
AlterWorkspace
BeginResolve
CommitResolve
CompressWorkspace
CompressWorkspaceTree
CopyForUpdate
CreateSavepoint
CreateWorkspace
DeleteSavepoint
DisableVersioning
EnableVersioning
FreezeWorkspace
GetConflictWorkspace
GetDiffVersions
GetLockMode
GetMultiWorkspaces
GetOpContext
GetPrivs
GetWorkspace
GotoDate
GotoSavepoint
GotoWorkspace
GrantSystemPriv
GrantWorkspacePriv
IsWorkspaceOccupied
LockRows
MergeTable
MergeWorkspace
RefreshTable
RefreshWorkspace
RemoveWorkspace
RemoveWorkspaceTree
ResolveConflicts
RevokeSystemPriv
RevokeWorkspacePriv
RollbackResolve
RollbackTable
RollbackToSP
RollbackWorkspace
SetConflictWorkspace
SetDiffVersions
SetLockingOFF
SetLockingON
SetMultiWorkspaces
SetWoOverwriteOFF
SetWoOverwriteON
SetWorkspaceLockModeOFF
SetWorkspaceLockModeON
UnfreezeWorkspace
UnlockRows
3 Metadata Views
3.1 ALL_VERSION_HVIEW
3.2 ALL_WM_LOCKED_TABLES
3.3 ALL_WM_MODIFIED_TABLES
3.4 ALL_WM_RIC_INFO
3.5 ALL_WM_TAB_TRIGGERS
3.6 ALL_WM_VERSIONED_TABLES
3.7 ALL_WORKSPACE_PRIVS
3.8 ALL_WORKSPACE_SAVEPOINTS
3.9 ALL_WORKSPACES
3.10 DBA_WORKSPACE_SESSIONS
3.11 ROLE_WM_PRIVS
3.12 USER_WM_LOCKED_TABLES
3.13 USER_WM_MODIFIED_TABLES
3.14 USER_WM_PRIVS
3.15 USER_WM_RIC_INFO
3.16 USER_WM_TAB_TRIGGERS
3.17 USER_WM_VERSIONED_TABLES
3.18 USER_WORKSPACE_PRIVS
3.19 USER_WORKSPACE_SAVEPOINTS
3.20 USER_WORKSPACES
3.21 xxx_CONF Views
3.22 xxx_DIFF Views
3.23 xxx_LOCK Views
3.24 xxx_HIST Views
3.25 xxx_MW Views
A Installing Workspace Manager with Custom Databases
B Error Messages
Glossary
Index
Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.
Home
Book List
Index
Master Index
Feedback