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.

Documentation Accessibility

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

Accessibility of Code Examples in Documentation

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.

Accessibility of Links to External Web Sites in Documentation

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.

TTY Access to Oracle Support Services

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.

Part I, "Conceptual and Usage Information"

Provides conceptual and usage information about Workspace Manager.

Chapter 1, "Introduction to Workspace Manager"

Explains workspace management concepts.

Chapter 2, "Workspace Manager Events"

Describes support for the Workspace Manager event framework, which is built on the Oracle Advanced Queuing (AQ) capability.

Chapter 3, "Workspace Manager Valid Time Support"

Describes Workspace Manager support for valid time, also known as effective dating, with version-enabled tables.

Part II, "Reference Information"

Provides reference information about the Workspace Manager PL/SQL API (DBMS_WM package) and metadata views.

Chapter 4, "DBMS_WM Package: Reference"

Provides reference information about the Workspace Manager application programming interface.

Chapter 5, "Workspace Manager Metadata Views"

Describes metadata views created and maintained by Workspace Manager.

Part III, "Supplementary Information"

Provides provides supplementary information about Workspace Manager (appendixes and a glossary).

Appendix A, "Installing Workspace Manager with Custom Databases"

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.)

Appendix B, "Migrating to Another Workspace Manager Release"

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.

Appendix C, "Using Replication with Workspace Manager"

Describes Workspace Manager support for replication of all workspace-related entities, operations, and DML and DDL operations on version-enabled tables.

Appendix D, "Workspace Manager Error Messages"

Lists the error messages for Workspace Manager, with the cause and suggested user action for each error.


Defines important terms specific to Workspace Manager.

Related Documentation

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:

Convention Meaning
. . . 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 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.