|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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.
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.
See this link for workspace manager related static views.
For a little demonstration, follow example 1.