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

Last updated on NOVEMBER 16, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.