ORA-31626: job does not exist
In this passage I would like to talk about my experience with the error „ORA-31626: job does not exist“.
I’ve written a program that exports a few tables using the dbms_datapump package. I implemented these and successfully tested them on the version 11.2.0.4. However, the program has triggered runtime errors at customer as follows:
ERROR in line 1:
ORA-31626: job does not exist
ORA-06512: in „SYS.DBMS_SYS_ERROR“, line 79
ORA-06512: in „SYS.DBMS_DATAPUMP“, line 1137
ORA-06512: in „SYS.DBMS_DATAPUMP“, line 5285
ORA-06512: in line 57
This error surprised me. What is different on customer environment now than on my environment? The program is created by me and the user who runs the program is scripted by me and the customer has the same Oracle version 11.2.0.4! It was not a compile error, it was a runtime error. So my first suspicion was that maybe some ORA-00600 error occurred. In particular, the message „job does not exist“ has confused me. So I requested the customer to check the alert file for error messages. But everything was normal in the alert file!
Well I have no trace………. All I know is that Datapump has to create a master table for all its work when exporting (and importing too). The master table belongs to system user and is created in the default User-tablespace.
I asked the customer if he could create a table with the user and insert some data into it. The answer came quickly. The customer could create the table but could not add any data. He gets the following errors: ora-01950 no privileges on tablespace ‚users‘. For me it was a surprise, but at least the explanation for the problem.
The user is created from a script by myself! The script grants the user „RESOURCE“ role. And I know that in Oracle 11.2.0.4 Quota is hard-coded on tablespaces in this role. It was revealed that the customer revoked this role from my user. After granting quota on Users tablespace to my user the program worked fine.
Ahmed Fikri 