Oracle WorkSpace interpretation and Cases

1. Workspace Manager introduces Oracle Workspace Manager's architecture of creating different versions for different tables. Version Management (Workspace manager) is a new feature of Oracle 11g. It is embedded in the oracle database and allows developers and DBAs to manage multiple versions of data in the same database. It uses the workspace as the virtual environment to organize and manage product data and retain multiple versions of data. Compared with the traditional data version management method, it can save more time, capital investment and personnel investment.
Workspace Manager can help you control versions of multiple tables in the database. When a user table is started with version control, all rows in the table support multi-version storage. The version architecture is completely transparent to end users. Applications query, insert, update, and delete data in the database with version control at the beginning, just as they do not normally use the version function.
When version control is applied to tables in the database, you can query the version data of a record in the table that you want to query. If you do not want to use Version Control for a table, you can cancel Version Control for a version-based table.

1.1 A Workspace Manager architecture can exist in the Workspace Manager architecture database. For example, a Workspace can be the father of one or more workspaces. By default, when a Workspace is created, it always starts from the top-level database WORKSPACE, that is, the newly created Worspace is the son of the LIVE Workspace. The Workspace name is case-sensitive. The Workspace name cannot exceed 30 characters and the Workspace level cannot exceed 30 characters.
Figure 1 shows a Workspace architecture. Workspace1 and Workspace4 are the sons of LIVE Workspace. Workspace2 and Workspace3 constitute Workspace1 and Workspace5 constitute Workspace4 separately.

The following are examples:
L view the current Workspace
SQL> select dbms_wm.getworkspace from dual;

GETWORKSPACE
--------------------------------------------------------------------------------
LIVE
L create WORKSPACE1
SQL> exec dbms_wm.createworkspace (workspace => 'space1 ');

PL/SQL procedure successfully completed
L query Workspace Architecture Information
SQL> select workspace, parent_workspace, owner from user_workspaces;

WORKSPACE PARENT_WORKSPACE OWNER
------------------------------------------------------------------------------------------
WORKSPACE1 LIVE SS
L enter Workspace1
SQL> exec dbms_wm.gotoworkspace (workspace => 'workspace1 ');
L query the current Workspace
PL/SQL procedure successfully completed

SQL> select dbms_wm.getworkspace from dual;

GETWORKSPACE
--------------------------------------------------------------------------------
WORKSPACE1
L use the version control function for the TEST table in Workspace
SQL> exec dbms_wm.enableversioning (table_name => 'test', hist => 'view _ WO_OVERWRITE ');

PL/SQL procedure successfully completed
L cancel Version Control for the TEST table
Exec dbms_wm.disableversioning (table_name => 'test ');

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12