Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 30 of 52
This procedure applies all changes in a workspace to its parent workspace, and optionally removes the workspace.
DBMS_WM.MergeWorkspace( workspace IN VARCHAR2 [, create_savepoint IN BOOLEAN DEFAULT FALSE] [, remove_workspace IN BOOLEAN DEFAULT FALSE] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
All data in all version-enabled tables in workspace
is merged to the parent workspace of workspace
, and workspace
is removed if remove_workspace
is TRUE
.
While this procedure is executing, the current workspace is frozen in NO_ACCESS
mode and the parent workspace is frozen in READ_ONLY
mode.
If there are conflicts between the workspace being merged and its parent workspace, the merge operation fails and the user must manually resolve conflicts using the <table_name>_CONF view. (Conflict resolution is explained in Oracle9i Application Developer's Guide - Workspace Manager.)
If the remove_workspace
parameter value is TRUE
, the workspace to be merged must be a leaf workspace, that is, a workspace with no descendant workspaces. (For an explanation of workspace hierarchy, see Oracle9i Application Developer's Guide - Workspace Manager.)
An exception is raised if the user does not have the MERGE_WORKSPACE
privilege for workspace or the MERGE_ANY_WORKSPACE
privilege.
The following example merges changes in NEWWORKSPACE
to its parent workspace and removes (by default) NEWWORKSPACE
.
EXECUTE DBMS_WM.MergeWorkspace (`NEWWORKSPACE');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|