Oracle Workspace Manager is Invalid after the Upgrade Mainly because of ORA-942 Errors (Doc ID 1995056.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Workspace Manager - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

After upgraded the datatabase Oracle Workspace Manager is found to be invalid
This is a summary of the errors found in dba_errors for the WMSYS's invalid objects:

OWNER    NAME                           TYPE         
-------- ------------------------------ ------------
TEXT
--------------------------------------------------------------
WMSYS    ALL_WORKSPACES                 VIEW               
ORA-00942: table or view does not exist

WMSYS    WM$WORKSPACE_SESSIONS_VIEW     VIEW               
ORA-00942: table or view does not exist

WMSYS    WM_COMPRESS_BATCH_SIZES        VIEW               
ORA-00942: table or view does not exist

WMSYS    WM_DDL_UTIL                    PACKAGE BODY       
PLS-00364: loop index variable 'UNQ_EXPR_COL_REC' use is invalid

WMSYS    DBA_WORKSPACES                 VIEW              
ORA-00942: table or view does not exist

WMSYS    LTADM                          PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    LTADM                          PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    LTDTRG                         PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    LTRIC                          PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    LTUTIL                         PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    LT_EXPORT_PKG                  PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    NO_VM_ALTER_PROC               PROCEDURE         
PL/SQL: ORA-00942: table or view does not exist

WMSYS    NO_VM_DROP_PROC                PROCEDURE         
PL/SQL: ORA-00942: table or view does not exist

WMSYS    OWM_BULK_LOAD_PKG              PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    OWM_DDL_PKG                    PACKAGE BODY      
PLS-00364: loop index variable 'TABLE_REC' use is invalid

WMSYS    OWM_MIG_PKG                    PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    OWM_REPUTIL                    PACKAGE BODY      
PL/SQL: ORA-00942: table or view does not exist

WMSYS    UD_TRIGS                       PACKAGE BODY    
PL/SQL: ORA-00942: table or view does not exist

WMSYS    USER_WORKSPACES                VIEW            
ORA-00942: table or view does not exist



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