0 Replies Latest reply on Apr 12, 2018 1:13 AM by e779cab4-600b-4a5f-9316-7118c132ff65

    Error ORA-31626, someone have a workaround thats works

    e779cab4-600b-4a5f-9316-7118c132ff65

      I try the process, without success:

       

       

      Connected to: Oracle Database 12c Enterprise Edition Release

      12.2.0.1.0 - 64bit Production

      ORA-31626: job does not exist

       

      SQL> SELECT owner_name, job_name, operation, job_mode, state,

      attached_sessions FROM dba_datapump_jobs WHERE job_name NOT LIKE

      'BIN$%'

      ORDER BY 1,2;  2

       

      OWNER_NAME JOB_NAME             OPERATION    JOB_MODE     STATE        ATTACHED_SESSIONS

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

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

      SYS        SYS_EXPORT_FULL_01   EXPORT       FULL         NOT RUNNING                  0

       

       

       

      SYS        SYS_EXPORT_FULL_02   EXPORT       FULL         NOT RUNNING                  0

       

       

       

      SYS        SYS_EXPORT_FULL_03   EXPORT       FULL         NOT RUNNING                  0

       

       

       

      OWNER_NAME JOB_NAME             OPERATION    JOB_MODE     STATE        ATTACHED_SESSIONS

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

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

       

      SYS        SYS_EXPORT_FULL_04   EXPORT       FULL         NOT RUNNING                  0

       

       

       

      SYS        SYS_EXPORT_FULL_05   EXPORT       FULL         NOT RUNNING                  0

       

       

       

      SYS        SYS_EXPORT_FULL_06   EXPORT       FULL         NOT RUNNING                  0

       

       

      OWNER_NAME JOB_NAME             OPERATION    JOB_MODE     STATE        ATTACHED_SESSIONS

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

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

       

       

      SYS        SYS_EXPORT_FULL_07   EXPORT       FULL         NOT RUNNING                  0

       

       

       

      SYS        SYS_EXPORT_FULL_08   EXPORT       FULL         NOT RUNNING                  0

       

       

       

       

      8 rows selected.

       

      SELECT o.status, o.object_id, o.object_type, o.owner||'.'||object_name

      "OWNER.OBJECT"

      FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND

      o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;

        2

       

      STATUS   OBJECT_ID OBJECT_TYPE

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

      OWNER.OBJECT

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

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      VALID        73724 TABLE
      SYS.SYS_EXPORT_FULL_01

      VALID        73764 TABLE
      SYS.SYS_EXPORT_FULL_02

      VALID        73804 TABLE
      SYS.SYS_EXPORT_FULL_03


      STATUS   OBJECT_ID OBJECT_TYPE
      ------- ---------- -----------------------
      OWNER.OBJECT
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      VALID        73844 TABLE
      SYS.SYS_EXPORT_FULL_04

      VALID        73884 TABLE
      SYS.SYS_EXPORT_FULL_05

      VALID        73907 TABLE
      SYS.SYS_EXPORT_FULL_06


      STATUS   OBJECT_ID OBJECT_TYPE
      ------- ---------- -----------------------
      OWNER.OBJECT
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      VALID        73947 TABLE
      SYS.SYS_EXPORT_FULL_07

      VALID        73970 TABLE
      SYS.SYS_EXPORT_FULL_08

      SQL> drop table SYS.SYS_EXPORT_FULL_07;

      Table dropped.
      SQL> SELECT o.status, o.object_id, o.object_type,
      o.owner||'.'||object_name "OWNER.OBJECT"
      FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND
      o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;
        2
         2    3
      SQL> SELECT o.status, o.object_id, o.object_type,
      o.owner||'.'||object_name "OWNER.OBJECT"
      FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND
      o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;
        2
         2    3
      SQL> SELECT o.status, o.object_id, o.object_type,
      o.owner||'.'||object_name "OWNER.OBJECT"
      FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND
      o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;
        2

      STATUS   OBJECT_ID OBJECT_TYPE
      ------- ---------- -----------------------
      OWNER.OBJECT
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      VALID        73724 TABLE
      SYS.SYS_EXPORT_FULL_01

      VALID        73764 TABLE
      SYS.SYS_EXPORT_FULL_02

      VALID        73804 TABLE
      SYS.SYS_EXPORT_FULL_03


      STATUS   OBJECT_ID OBJECT_TYPE
      ------- ---------- -----------------------
      OWNER.OBJECT
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      VALID        73844 TABLE
      SYS.SYS_EXPORT_FULL_04

      VALID        73884 TABLE
      SYS.SYS_EXPORT_FULL_05

      VALID        73907 TABLE
      SYS.SYS_EXPORT_FULL_06


      STATUS   OBJECT_ID OBJECT_TYPE
      ------- ---------- -----------------------
      OWNER.OBJECT
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      VALID        73970 TABLE
      SYS.SYS_EXPORT_FULL_08


      7 rows selected.

      SQL> drop table SYS.SYS_EXPORT_FULL_06;

      Table dropped.

      SQL> drop table SYS.SYS_EXPORT_FULL_05;

      Table dropped.

      SQL> drop table SYS.SYS_EXPORT_FULL_04;

      Table dropped.

      SQL> drop table SYS.SYS_EXPORT_FULL_03;

      Table dropped.

      SQL> drop table SYS.SYS_EXPORT_FULL_02;

      Table dropped.

      SQL> SELECT o.status, o.object_id, o.object_type,
      o.owner||'.'||object_name "OWNER.OBJECT"
      FROM dba_objects o, dba_datapump_jobs j WHERE o.owner=j.owner_name AND
      o.object_name=j.job_name AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;
        2

      STATUS   OBJECT_ID OBJECT_TYPE
      ------- ---------- -----------------------
      OWNER.OBJECT
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      VALID        73724 TABLE
      SYS.SYS_EXPORT_FULL_01

      VALID        73970 TABLE
      SYS.SYS_EXPORT_FULL_08


      SQL> drop table SYS.SYS_EXPORT_FULL_01;

      Table dropped.

      SQL> drop table SYS.SYS_EXPORT_FULL_08;

      Table dropped.

      Connected to: Oracle Database 12c Enterprise Edition Release
      12.2.0.1.0 - 64bit Production
      ORA-31626: job does not exist