Oracle Database Application Developer's Guide - Workspace Manager describes Oracle Workspace Manager, often referred to as Workspace Manager, which lets applications create workspaces and group different versions of table row values in different workspaces.
This preface contains these topics:
Oracle Database Application Developer's Guide - Workspace Manager is intended for application designers and developers. It is assumed that you have some experience programming in PL/SQL.
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week. For TTY support, call 800.446.2398.
This document contains the following elements:
This guide has two main parts (conceptual and usage information, and reference information) and a third part with supplementary information (appendixes and a glossary). The first part is organized for efficient learning about Workspace Manager; it covers basic concepts and techniques first, and proceeds to more advanced material (such as Workspace Manager events and valid time support).
This guide has the following elements.
Provides conceptual and usage information about Workspace Manager.
Explains workspace management concepts.
Describes support for the Workspace Manager event framework, which is built on the Oracle Advanced Queuing (AQ) capability.
Describes Workspace Manager support for valid time, also known as effective dating, with version-enabled tables.
Provides reference information about the Workspace Manager PL/SQL API (DBMS_WM package) and metadata views.
Provides reference information about the Workspace Manager application programming interface.
Describes metadata views created and maintained by Workspace Manager.
Provides provides supplementary information about Workspace Manager (appendixes and a glossary).
Describes how to install Workspace Manager with Oracle databases other than the seed database and databases created using the Database Configuration Assistant (DBCA). (Workspace Manager is installed by default in the seed database and databases using DBCA.)
Describes how to migrate (upgrade or downgrade) from one Workspace Manager release to another, if you have version-enabled tables with data that you want to preserve from one release to the other.
Describes Workspace Manager support for replication of all workspace-related entities, operations, and DML and DDL operations on version-enabled tables.
Lists the error messages for Workspace Manager, with the cause and suggested user action for each error.
Defines important terms specific to Workspace Manager.
For more information about using this product in a development environment, see the following documents:
Printed documentation is available for sale in the Oracle Store at
To download free release notes, installation documentation, white papers, or other collateral, go to the Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at
If you already have a username and password for OTN, then you can go directly to the documentation section of the OTN Web site at
In examples, an implied carriage return occurs at the end of each line, unless otherwise noted. You must press the Return key at the end of a line of input.
The following conventions are used in this guide:
|. . .||Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted.|
|boldface text||Boldface text indicates a term defined in the text, the glossary, or in both locations.|
|italic text||Italic text is used for book titles, emphasis, and some special terms.|
||Monospace text is used for the names of parameters, files, and directory paths. It is also used for SQL and PL/SQL code examples.|
|< >||Angle brackets enclose user-supplied names.|
|[ ]||Brackets enclose optional clauses from which you can choose one or none.|