|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_WM , 31 of 52
This procedure applies to a workspace all changes made to a table (all rows or as specified in the
WHERE clause) in its parent workspace.
DBMS_WM.RefreshTable( workspace IN VARCHAR2, table_id IN VARCHAR2 [, where_clause IN VARCHAR2 DEFAULT ''] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
Name of the workspace. The name is case sensitive.
Name of the savepoint. The name is case sensitive.
This procedure applies to
workspace all changes in rows that satisfy the
where_clause in the version-enabled table
table_id 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.)
A table cannot be refreshed in the
LIVE workspace (because that workspace has no parent workspace).
A table cannot be merged or refreshed if there is an open regular transaction affecting the table.
An exception is raised if the user does not have access to
table_id, or the
MERGE_WORKSPACE privilege for
workspace or the
The following example refreshes
NEWWORKSPACE by applying changes made to the
EMPLOYEES table where
last_name = 'Smith' in its parent workspace.