Invalid WMSYS objects in DBA_OBJECTS
I have the following invalid WMSYS objects in the database:
OWNER OBJECT_NAME OBJECT_TYPE
--------------- ------------------------- ------------------------
WMSYS LTUTIL PACKAGE
WMSYS OWM_DDL_PKG PACKAGE BODY
WMSYS LTDDL PACKAGE BODY
WMSYS LT_EXPORT_PKG PACKAGE BODY
WMSYS LTUTIL PACKAGE BODY
Oracle Note 2397876.1 solution is to do grants and compile WMSYS.LTUTIL I got the error below :
Grant the following privileges to WMSYS
grant insert on SYS.NOEXP$ to WMSYS;
grant delete on SYS.NOEXP$ to WMSYS;
then compile the package
SQL> alter package WMSYS.LTUTIL compile;
Warning: Package altered with compilation errors.
SQL> show errors
Errors for PACKAGE WMSYS.LTUTIL: