Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Help ORA - 31626: job does not exist

994122May 28 2014 — edited May 31 2014

Hi


I have to update my database with data from a dmp file, but when performing import the following error message appears:

UDI - 31626: OPERATION GENERATEX ORALCE ERROR 361626

ORA - 31626: job does not exist

ORA - 06512: AT "SYS.DBMS_SYS_ERROR", line 79

ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 1137

ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 3414

ORA - 06512: AT "SYS.DBMS_SYS_DATAPUMP", line 4593

ORA - 06512: AT line 1

Anyone ever encountered this error and know how to solve?

thank you

Comments

unknown-698157

When you would have Googled for this error (which you obviously didn't)

you would have found 4500+ hits.

Can you explain to this forum why you didn't Google for this error, please?

------------

Sybrand Bakker

Senior Oracle DBA

994122

Thanks

ASulthan

Hi

I think the reason seems to be a bug, it is known and you can find it on metalink

Gaurav_91

Hi,

Look at your import log file,  your import is completed successfully  but it is no more visible on command prompt.

That is why on command prompt, it is showing ORA - 31626: job does not exist.

994122 
Gaurav_91 wrote:




Hi,




Look at your import log file,  your import is completed successfully  but it is no more visible on command prompt.




That is why on command prompt, it is showing ORA - 31626: job does not exist.

Thanks for the reply

but I needed to execute the catproc.sql

SQL >@ $ORACLE_HOME/rdbms/admin/catproc.sql



Thanks

994122

could anyone please help me?

smit_sign-Oracle

Imprting from which version to which version?

Also AQ_TM_PROCESSES=0??

Smit

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 26 2014
Added on May 28 2014
#database-key-features, #export-import-sql-loader-external-tables
7 comments
7,894 views