Database Utilities (MOSC)

MOSC Banner

ORA-31626 job does not exist during execution of DBMS_DATAPUMP API

edited May 19, 2020 5:03AM in Database Utilities (MOSC) 5 commentsAnswered

Hi all

I have strange problem with execution of procedure which calls : For description

I have user DBSRV  and procedure p_DataPump which work correct , I created user TEST1 with privileges to execution DBSRV.p_DataPump  and also work correct .

But when one client connect to TEST1 and execute DBSRV.p_Datapump it crash to ORA-31626 job does not exist.

Version of database is 12.1.0.2.0 on aix 7.1

I tried to trace it :

=====================

PARSING IN CURSOR #4863613944 len=6 dep=1 uid=76 oct=44 lid=76 tim=29870630560538 hv=255718823 ad='0' sqlid='8ggw94h7mvxd7'

COMMIT

END OF STMT

PARSE #4863613944:c=2,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=29870630560537

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