Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 10 of 52
This procedure creates a new workspace in the database.
DBMS_WM.CreateWorkspace( workspace IN VARCHAR2 [, isrefreshed IN BOOLEAN DEFAULT FALSE] [, description IN VARCHAR2 DEFAULT NULL] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
or
DBMS_WM.CreateWorkspace( workspace IN VARCHAR2, isrefreshed IN BOOLEAN [, description IN VARCHAR2 DEFAULT NULL] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
Parameter | Description |
---|---|
workspace |
Name of the workspace. The name is case sensitive, and it must be unique (no other workspace of the same name). |
isrefreshed |
A boolean value (
If you use the syntax without the |
description |
Description of the workspace. |
auto_commit |
A boolean value (
|
The new workspace is a child of the current workspace. If the session has not explicitly entered a workspace, it is in the LIVE
database workspace, and the new workspace is a child of the LIVE
workspace. For an explanation of database workspace hierarchy, see Oracle9i Application Developer's Guide - Workspace Manager.
An implicit savepoint is created in the current version of the current workspace. (The current version does not have to be the latest version in the current workspace.) For an explanation of savepoints (explicit and implicit), see Oracle9i Application Developer's Guide - Workspace Manager.
While this procedure is executing, the current workspace is frozen in READ_ONLY
mode.
This procedure does not implicitly go to the workspace created. To go to the workspace, use the GotoWorkspace Procedure.
An exception is raised if one or more of the following apply:
The following example creates a workspace named NEWWORKSPACE
in the database.
EXECUTE DBMS_WM.CreateWorkspace ('NEWWORKSPACE');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|