4 Replies Latest reply: Nov 16, 2012 12:43 AM by KSG RSS

    dbms_scheduler --ORA-39002: invalid operation

      Hi, 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