SetMultiWorkspaces Procedure

This procedure makes the specified workspace or workspaces visible in the multiworkspace views for version-enabled tables.

Syntax

DBMS_WM.SetMultiWorkspaces(
   workspaces  IN VARCHAR2);

Parameters

Table 70-39 SetMultiWorkspaces Procedure Parameters  

Parameter	Description
workspaces	The workspace or workspaces for which information is to be added to the multiworkspace views. The workspace names are case sensitive. To specify more than one workspace (but no more than eight), use a comma to separate workspace names. For example: 'workspace1,workspace2'

Usage Notes

This procedure adds rows to the multiworkspace views (xxx_MS). See Oracle9i Application Developer's Guide - Workspace Manager for information about the contents and uses of these views.

To see the names of workspaces visible in the multiworkspace views, use the GetMultiWorkspaces Function function.

An exception is raised if one or more of the following apply:

• The user does not have the privilege to go to one or more of the workspaces named in workspaces.

• A workspace named in workspaces is not valid.

• More than eight workspace names are specified in workspaces.

Examples

The following example adds information to the multiworkspace views for version-enabled tables in the B_focus_1 workspace.

SQL> EXECUTE DBMS_WM.SetMultiWorkspaces ('B_focus_1');