Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 32 of 52
This procedure applies to a workspace all changes made in its parent workspace.
DBMS_WM.RefreshWorkspace( workspace IN VARCHAR2 [, auto_commit IN BOOLEAN DEFAULT TRUE]);
This procedure applies to workspace
all changes made to version-enabled tables in the parent workspace since the time when workspace
was created or last refreshed.
If there are conflicts between the workspace being refreshed and its parent workspace, the refresh 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.)
The specified workspace and the parent workspace are frozen in READ_ONLY
mode.
The LIVE
workspace cannot be refreshed (because it has no parent workspace).
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 refreshes NEWWORKSPACE
by applying changes made in its parent workspace.
EXECUTE DBMS_WM.RefreshWorkspace (`NEWWORKSPACE');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|