Skip Headers
Oracle9
i
Application Developer's Guide - Workspace Manager
Release 2 (9.2)
Part Number A96628-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
Audience
Documentation Accessibility
Organization
Related Documentation
Conventions
New and Changed Features
DDL Support Related to Version-Enabled Tables
Replication Support for Workspace Manager
Migration Support Procedures
Session Context Information
Synonym Support for Table Names
Multilevel Referential Integrity Support
New Privileges: FREEZE_WORKSPACE and FREEZE_ANY_WORKSPACE
WM_INSTALLATION View
STATE Column added to xxx_WM_VERSIONED_TABLES Views
New Columns Added to xxx_WORKSPACES Views
New Columns Added to xxx_WORKSPACE_SAVEPOINTS Views
"Ignore Last Error" Option
FreezeWorkspace Options
CompressWorkspace Options and Behavior Changes
1 Introduction
1.1 Workspace Manager Overview
1.1.1 Workspace Hierarchy
1.1.2 Using Savepoints
1.1.2.1 Design Issue: Savepoint or Child Workspace?
1.1.3 Merging and Rolling Back Workspace Changes
1.1.4 Resolving Conflicts Before a Merge or Refresh Operation
1.1.5 Freezing and Unfreezing Workspaces
1.1.6 Removing Workspaces
1.1.7 Autocommitting of Workspace Manager Operations
1.1.8 Infrastructure for Version-Enabling of Tables
1.1.9 Workspace Manager Schema, Metadata, and Package
1.2 Session Context Information
1.3 Lock Management
1.4 Privilege Management
1.5 Import and Export Considerations
1.6 DDL Operations Related to Version-Enabled Tables
1.7 Referential Integrity Support
1.8 Triggers on Version-Enabled Tables
1.9 Support for Table Synonyms
1.10 Procedure Categories
1.10.1 Table Management Procedures
1.10.2 Workspace Management Procedures
1.10.3 Savepoint Management Procedures
1.10.4 Privilege Management Procedures
1.10.5 Lock Management Procedures
1.10.6 Conflict Management Procedures
1.10.7 Replication Support Procedures
1.11 Simplified Example
2 Procedures: Reference
AlterSavepoint
AlterWorkspace
BeginDDL
BeginResolve
CommitDDL
CommitResolve
CompressWorkspace
CompressWorkspaceTree
CopyForUpdate
CreateSavepoint
CreateWorkspace
DeleteSavepoint
DisableVersioning
DropReplicationSupport
EnableVersioning
FreezeWorkspace
GenerateReplicationSupport
GetConflictWorkspace
GetDiffVersions
GetLockMode
GetMultiWorkspaces
GetOpContext
GetPrivs
GetSessionInfo
GetWorkspace
GotoDate
GotoSavepoint
GotoWorkspace
GrantSystemPriv
GrantWorkspacePriv
IsWorkspaceOccupied
LockRows
MergeTable
MergeWorkspace
RecoverAllMigratingTables
RecoverMigratingTable
RefreshTable
RefreshWorkspace
RelocateWriterSite
RemoveWorkspace
RemoveWorkspaceTree
ResolveConflicts
RevokeSystemPriv
RevokeWorkspacePriv
RollbackDDL
RollbackResolve
RollbackTable
RollbackToSP
RollbackWorkspace
SetConflictWorkspace
SetDiffVersions
SetLockingOFF
SetLockingON
SetMultiWorkspaces
SetWoOverwriteOFF
SetWoOverwriteON
SetWorkspaceLockModeOFF
SetWorkspaceLockModeON
SynchronizeSite
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_WM_VT_ERRORS
3.8 ALL_WORKSPACE_PRIVS
3.9 ALL_WORKSPACE_SAVEPOINTS
3.10 ALL_WORKSPACES
3.11 DBA_WORKSPACE_SESSIONS
3.12 ROLE_WM_PRIVS
3.13 USER_WM_LOCKED_TABLES
3.14 USER_WM_MODIFIED_TABLES
3.15 USER_WM_PRIVS
3.16 USER_WM_RIC_INFO
3.17 USER_WM_TAB_TRIGGERS
3.18 USER_WM_VERSIONED_TABLES
3.19 USER_WM_VT_ERRORS
3.20 USER_WORKSPACE_PRIVS
3.21 USER_WORKSPACE_SAVEPOINTS
3.22 USER_WORKSPACES
3.23 WM_INSTALLATION
3.24 WM_REPLICATION_INFO
3.25 xxx_CONF Views
3.26 xxx_DIFF Views
3.27 xxx_LOCK Views
3.28 xxx_HIST Views
3.29 xxx_MW Views
A Installing Workspace Manager with Custom Databases
B Migrating to Another Workspace Manager Release
B.1 Upgrading to the Current Release
B.2 Downgrading to a Previous Release
C Using Replication with Workspace Manager
C.1 Setting Up Replication with Workspace Manager
C.2 Enabling and Disabling Versioning of Tables with Replication Support
C.3 DDL Operations with Replicated Version-Enabled Tables
C.4 Relocating the Writer Site
D Error Messages
Glossary
Index
Copyright © 2000, 2002 Oracle Corporation.
All Rights Reserved.
Home
Book List
Index
Master Index
Feedback