Oracle DB, Workspace Manager

Материал из sysadm
Перейти к навигации Перейти к поиску

OWM (Oracle Workspace Manager)

Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, proposed and historical versions of data in the same database. Applications and DBA operations often work with more than one version of the data. Three common reasons to have multiple data versions are concurrency, auditing and scenario creation. Oracle Workspace Manager provides workspaces as a virtual environment to isolate a collection of changes to production data, keep a history of changes to data and create multiple data scenarios for “what if” analysis. It can save money, time and labor over traditional approaches.

-- список рабочих областей (workspace)
select owner,workspace,FREEZE_STATUS,FREEZE_MODE,FREEZE_WRITER,FREEZE_OWNER from all_workspaces;


Ссылки по теме