Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

SYS.DBMS_REDEFINITION package body is showing as Invalid

edited Sep 30, 2014 5:01AM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered

I am running the pre upgrade script and "SYS.DBMS_REDEFINITION" is showing as invalid PACKAGE BODY:

SQL> select owner,object_name,object_id,object_type,created,last_ddl_time,timestamp,status from dba_objects where status = 'INVALID' order by object_name;

 

OWNER

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

OBJECT_NAME

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

  OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_ TIMESTAMP STATUS

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

SYS

DBMS_REDEFINITION

  8545 PACKAGE BODY 17-AUG-09 19-SEP-14 2014-09-19:11:42:28 INVALID

 

I have already ran "utlrp.sql" but still is showing as INVALID.

 

I have also tried the following but no deference:

 

SQL> alter package DBMS_REDEFINITION compile body;

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