Database Administration (MOSC)

MOSC Banner

Invalid package body in SYS schema

edited Jan 28, 2010 1:12AM in Database Administration (MOSC) 8 commentsAnswered
Hi,
The following package bodies are in invalid state in my database. I cannot compile them. I tried to compile them with the utlrp.sql script and also one by one.

If I try to compile them I receive the following error message:  Error(1): PLS-00753: malformed or corrupted wrapped unit

Any suggestion would be appreciated.

System info:  10.2.0.3 Standard Edition RAC, Solaris X86-64


OWNER                          OBJECT_NAME                    SUBOBJECT_NAME                  OBJECT_ID OBJECT_TYPE         CREATED   LAST_DDL_ STATUS  TIMESTAMP           T G S
------------------------------ ------------------------------ ------------------------------ ---------- ------------------- --------- --------- ------- ------------------- - - -
SYS                            DBMS_DEFER_SYS                                                      5054 PACKAGE BODY        09-DEC-08 21-JAN-10 INVALID 2010-01-21:14:29:39 N N N

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