Database Utilities (MOSC)

MOSC Banner

with expdp, getting ORA-39127: unexpected error from call to TAG: SCHEDULER

edited Sep 21, 2021 11:07PM in Database Utilities (MOSC) 9 commentsAnswered

When exporting a database by EXPDP, I am getting the following error stack:


ORA-39127: unexpected error from call to TAG: SCHEDULER Calling: SYS.DBMS_SCHED_JOB_EXPORT.GRANT_EXP obj: xxxx.REFRESH_OVERZICHT_JOB - SCHEDULER JOB

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2704

ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 53

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2704

ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 53

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_METADATA", line 11144

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95


This happen almost always, but not every time. The scheduled job REFRESH_OVERZICHT_JOB runs during the EXPDP, in fact it runs every 15 minutes while the export takes about one-and-a-half hours.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center