|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.
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.
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.