ORA-31626: job does not exist during schema export
0
votes
1
answer
2856
views
I'm exporting schema with following command -
expdp system/system@xxx.xxx.xxx.xxx:1521/orcl schemas=schema-name directory=test_dir dumpfile=Schema.dmp logfile=SchemaLog.log
but it results into following error -
Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
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 1009
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 googled a lot and tried solutions provided around
ORA-31626: job does not exist
and ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors
but none helped to solve the problem.
Could you please help to resolve this?
Asked by Alpha
(153 rep)
Dec 30, 2020, 08:58 AM
Last activity: Jul 27, 2025, 12:06 PM
Last activity: Jul 27, 2025, 12:06 PM