ORACLE WORKSPACE INTEGRATION-IMPORTANT DBMS PACKAGES

ORACLE WORKSPACE INTEGRATION

We can create a workspace simply

SQL>exec dbms_wm.createworkspace('WORKSPACE_NAME');

grant workspace privileges to a particular user:
SQL>exec dbms_wm.grantworkspacepriv('ACCESS_WORKSPACE','WORKSPACE_NAME','username');

We can find out current workspaces associated with users

wmsys.wm$workspace_sessions_view

We can resolve conflit of a particular workspace

SQL>exec dbms_wm.SetConflictWorkspace('WORKSPACE_NAME');

After that conflit we need to commit
by

SQL>exec dbms_wm.commitresolve('WORKSPACE_NAME');

We can find out Current workspace

SQL>SELECT DBMS_WM.getworkspace FROM DUAL;

We can connect to a particular workspace

SQL>EXEC dbms_wm.gotoworkspace('WORKSPACE_NAME');

We can merge that particular workspace to parent

SQL>EXEC dbms_wm.mergeworkspace('WORKSPACE_NAME');

We can freeze a workspace to disallow changes to rows in the version-enabled tables

SQL>dbms_wm.freezeworkspace('WORKSPACE_NAME');

reverse this process
by

SQL>exec dbms_wm.unfreezeworkspace('WORKSPACE_NAME');

we can refresh workspace..if we have any conflint,we can find out after refreshing workspace:

SQL> exec dbms_wm.refreshworkspace(' WORKSPACE_NAME');

We can remove a workspace

by

SQL> exec dbms_wm.removeworkspace(' WORKSPACE_NAME');