Hi ,
catupgrd.sql script is failing with below error at the end.
begin
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STATS
ORA-21700: object does not exist or is marked for delete
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
ORA-06512: at line 2
while investigating further i got below errors
SQL> alter package DBMS_STATS compile body;
alter package DBMS_STATS compile body
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_STATS_INTERNAL
ORA-21700: object does not exist or is marked for delete
SQL> alter package DBMS_STATS_INTERNAL compile ;
alter package DBMS_STATS_INTERNAL compile
*
ERROR at line 1:
ORA-21700: object does not exist or is marked for delete
Please suggest on this.