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