4 Replies Latest reply: Jul 15, 2014 8:40 AM by Nino Putra RSS

    ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors

    Nino Putra

      Hi guys..when I try to export schema, some error has occurred

       

      ORA-31626: job does not exist
      ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_INTERNAL_LOGSTDBY"
      ORA-06512: at "SYS.KUPV$FT", line 991
      ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
      

       

      I had following this thread

      Navaneeth's Blog: ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors;ORA-06508: PL/SQL: could not…

       

      but nothing work

      when I check using these script, I know if I lost one of my table,,, LOGMNR_LOG$

      SELECT owner, object_type, object_name, object_id, status FROM SYS.dba_objects

      where object_name = 'DBMS_INTERNAL_LOGSTDBY';

       

      SELECT object_name FROM SYS.DBA_OBJECTS B ,PUBLIC_DEPENDENCY A WHERE A.OBJECT_ID = 11692 AND A.REFERENCED_OBJECT_ID = B.OBJECT_ID AND OBJECT_TYPE = 'TABLE' ORDER BY OWNER, OBJECT_NAME;

       

      so I run the catproc.sql script the run the utlrp.sql to compile the invalid objects

      but nothing work..

       

      any advice??

       

      thank you