Skip to Main Content

Oracle Database Discussions

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!

expdp error but successfully completed

chileme88May 22 2018 — edited May 22 2018

Hi,

I'm run an expdp job from the remote server for the production server.

Export: Release 11.2.0.3.0 - Production on Mon May 21 22:13:59 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

Some day (this script runs every night) in my remote server my expdp exit code is 1 and if I check the redirected output I find:

UDE-31626: operation generated ORACLE error 31626

ORA-31626: job does not exist

ORA-39086: cannot retrieve job information

ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551

ORA-06512: at line 1

But if i check the local log on the production server I found:

Job "ORABACKUP"."SYS_EXPORT_FULL_01" successfully completed at 23:19:49

Is this a bug? Is there some solution for have  return code 0 ?

This post has been answered by DeepC on May 22 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2018
Added on May 22 2018
6 comments
740 views