Skip Headers

Table of Contents Image Oracle9i Application Developer's Guide - Workspace Manager
Release 2 (9.2)

Part Number A96628-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback

Go to next page

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


Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback