Skip to Main Content

SQL Developer

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!

SQL Developer - ORA-31626: job does not exist

user1297334Jan 16 2018 — edited Jan 18 2018

I am having a very frustrating problem.  We are moving from 11.2.0.1 to 12.2.0.1 and I am using data pump to move the data.

A few details:

The 11g and 12c databases are on different servers

11g server is running Solaris 10 on Sparc

12c server is Solaris 11 on Sparc

Using SQL developer version 17.4.0.355

I have created the export files (by schema) from 11g using SQL Developer and moved the files to the data pump directory on the new server.

When I try to import a schema using the data pump import wizard of SQL Developer I get ORA-31626: job does not exist.   There are no other jobs running.

I was able to import the data at the command line using impdp.

Any idea why I would get the error in SQL Developer, but not at the command line?

Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2018
Added on Jan 16 2018
5 comments
4,485 views