SetConflictWorkspace Procedure

This procedure determine whether or not conflicts exist between a workspace and its parent.

Syntax

DBMS_WM.SetConflictWorkspace(
   workspace  IN VARCHAR2);

Parameters

Table 70-36 SetConflictWorkspace Procedure Parameters  

Parameter	Description
workspace	Name of the workspace. The name is case sensitive.

Usage Notes

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

Examples

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');