Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 42 of 52
This procedure determine whether or not conflicts exist between a workspace and its parent.
DBMS_WM.SetConflictWorkspace( workspace IN VARCHAR2);
Parameter | Description |
---|---|
workspace |
Name of the workspace. The name is case sensitive. |
This procedure checks for any conflicts between workspace
and its parent workspace, and it modifies the contents of the <table_name>_CONF views (explained in Oracle9i Application Developer's Guide - Workspace Manager.) as needed.
A SELECT
operation from the <table_name>_CONF views for all tables modified in a workspace displays all rows in the workspace that are in conflict with the parent workspace. (To obtain a list of tables that may have been changed in the workspace, use the SQL statement SELECT * FROM ALL_VERSIONED_TABLES
. The SQL statement SELECT * FROM <table_name>_CONF
displays conflicts for <table_name> between the current workspace and its parent workspace.)
Any conflicts must be resolved before a workspace can be merged or refreshed. To resolve a conflict, you must use the ResolveConflicts Procedure (and then merge the result of the resolution by using the MergeWorkspace Procedure).
The following example checks for any conflicts between B_focus_2
and its parent workspace, and modifies the contents of the <table_name>_CONF views as needed.
EXECUTE DBMS_WM.SetConflictWorkspace ('B_focus_2');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|