DBMS_* packages under the user SYS are INVALID
Posted on 2007-11-29
I have done a database refresh to refresh a user schema with production data.
This is a process I run often, however I encountered errors right away - in the import process when refreshing the user schema and saw these errors in the log:
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
IMP-00046: using FILESIZE value from export file of 1999998976
. importing USERDB's objects into USERDB_MOD
IMP-00017: following statement failed with ORACLE error 4068:
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_LOGREP_IMP" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 2304:
Please note: the error ORA-04063: package body "SYS.DBMS_LOGREP_IMP" has errors
I went into TOAD and noted that there are many DBMS_* packages are INVALID, not about 20 or so.
I did run the following script to recompile objects that belong to SYS:
connect / as sysdba
set echo off
set feedback off
set pagesize 999
set linesize 99
However, this did not resolve the problem.
Can anyone help me figure out how to resolve this problem.
Thank you very much.