|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.
Name of the workspace. The name is case sensitive.
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
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
The following example refreshes
NEWWORKSPACE by applying changes made in its parent workspace.