This discussion is archived
4 Replies Latest reply: Nov 15, 2012 10:43 PM by KSG RSS

dbms_scheduler --ORA-39002: invalid operation

KSG Explorer
Currently Being Moderated
Hi,

10.2.0.4 on Linux.

A datapump export job failed with below error, which is scheduled in the dbms_scheduler.

ORA-39002: invalid operation

Strangely, job automatically runs successfully after sometimes after the error.

As as workaround, we have re-created the procedure and schedule the job.. Now, the job fails with ORA error (even job is not running automatically after failure).

When I manually execute the job, it runs successfully.

Any suggestions please

Regards
KSG

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points