My Oracle Support Banner

After Upgrade From To There Are WMSYS Objects Not In Sync (Doc ID 1516195.1)

Last updated on JANUARY 30, 2022

Applies to:

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


After upgrading to ( Multimedia is invalid and there are several WMSYS objects
invalid due to the error ORA-942 Table or View does not exist.

All the public synonyms for SYS objects as well as the privilege to use them existed, therefore this is not a problem

The result of the query

suggested in
HCKW-0016 - Dependency$ p_timestamp mismatch for VALID objects (Doc ID 1361045.1)
as well the hcheck.sql script from
"hcheck.sql" script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g (Doc ID 136697.1)
show there is a problem with timestamps out of sync:

D_NAME                             D_TYPE OWNER
------------------------------ ---------- ------------------------------   

P_OBJ P_NAME                         P_Timestamp

---------- ------------------------------ -----------------------------

STIME                         X
----------------------------- --------
WM$VERSIONED_TABLES                     2 WMSYS      
9896 WM$ED_UNDO_CODE_TABLE_TYPE     29-JUL-2001 12:08:55
18-NOV-2012 08:50:02          *DIFFER*

9895 WM$ED_UNDO_CODE_NODE_TYPE      29-JUL-2001 12:08:55

18-NOV-2012 08:50:02          *DIFFER*

XDB$NLOCKS                              2 XDB     41457
XDB$NLOCKS_T                   10-NOV-2008 10:40:55
18-NOV-2012 08:48:45          *DIFFER*

XDW1RlNY2a0P7gQwrSJxHQ/g==             55 XDB    
41603 privilegeNameType1_T           10-NOV-2008 10:41:02
18-NOV-2012 08:48:45          *DIFFER*




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

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