Error When Executing DBMS_WM.SetDiffVersions

(Doc ID 2247660.1)

Last updated on APRIL 21, 2017

Applies to:

Workspace Manager - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Error when executing DBMS_WM.SetDiffVersions

BEGIN DBMS_WM.SetDiffVersions('<WORKPSPACE>','LIVE'); END;
Error at line 4
ORA-20235: invalid system parameter name or value
ORA-06512: at "WMSYS.LT", line 8911
ORA-06512: at "WMSYS.LT", line 8916
ORA-06512: at line 1

********************************

WORKSPACE MANAGER COMPONENT STATUS

COMP_ID STATUS VERSION COMP_NAME
------------ ---------- --------------- -----------------------------
OWM VALID 11.2.0.4.0 Oracle Workspace Manager

SQL> SELECT COUNT(*) FROM V$PARAMETER;

COUNT(*)
----------
352

 

SQL> select * from wm_installation;

NAME                                                   VALUE
------------------------------------        ---------------------
ADD_UNIQUE_COLUMN_TO_HISTORY_VIEW OFF
ALLOW_CAPTURE_EVENTS                       OFF
ALLOW_MULTI_PARENT_WORKSPACES       OFF
ALLOW_NESTED_TABLE_COLUMNS            OFF
COMPRESS_PARENT_AFTER_REMOVE         ON
CR_WORKSPACE_MODE                           OPTIMISTIC_LOCKING
FIRE_TRIGGERS_FOR_NONDML_EVENTS      ON
KEEP_REMOVED_WORKSPACES_INFO         OFF
NONCR_WORKSPACE_MODE                     OPTIMISTIC_LOCKING
NUMBER_OF_COMPRESS_BATCHES            50
OWM_VERSION                                     11.2.0.4.0
ROW_LEVEL_LOCKING                            OFF
TARGET_PGA_MEMORY                          8388608
UNDO_SPACE                                      UNLIMITED
USE_SCALAR_TYPES_FOR_VALIDTIME     OFF
USE_TIMESTAMP_TYPE_FOR_HISTORY    ON

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms