Oracle9i Workspace Manager is a new feature of Oracle9i that transparently and securely versions relational content in place with no changes to application SQL (DML), while permitting simultaneous read and write access to the same production data.

Applications use a PL/SQL stored procedure to set users in a workspace. Once in a workspace, changes to data in version-enabled tables (using existing application SQL) create new row versions (within the same tablespace) that are only visible within the workspace until explicitly merged with production data. Or, changes can be rolled back to a specific point in time through the use of savepoints.


http://technet.oracle.com/products/w...rkspace_QA.htm