PL/SQL (MOSC)

MOSC Banner

Invalid WMSYS objects in DBA_OBJECTS

in PL/SQL (MOSC) 5 commentsAnswered

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center