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:
Workspace Manager - Version 11.2.0.4 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |