René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

The Oracle Workspace Manager

The Oracle Workspace Manager is a 'tool' that enables versioning. This makes it possible to go back in time and query data as valid of a date in the past.
The functionality (Packages, Procedures, Functions) used for the Workspace Manager are found in the wmsys schema.

Versioned tables

Each table that is versioned with the workspace manager must have a primary key. Otherwise, Oracle will throw a ORA-20133: table 'SCHEMA.TABLENAME' needs to have a primary key.
Conversly, the tables cannot have a unique constraint. At least not in 9i, I didn't check in 10g.

Static views

See this link for workspace manager related static views.

Links

For a little demonstration, follow example 1.