ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM When Exporting With Datapump (Doc ID 816839.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 29 Feb 2016***

Symptoms

Linux x86-64 running oracle 10.2.0.4 getting errors on expdp in a RAC database.

ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 893
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-31632: master table "SYSTEM.SYS_EXPORT_SCHEMA_01" not found, invalid, or inaccessible
ORA-31635: unable to establish job resource synchronization
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2057
ORA-04065: not executed, altered or dropped stored procedure "SYS.DBMS_LOCK"
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOCK"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms