This content has been marked as final. Show 4 replies
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
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..