0 Replies Latest reply on Jun 28, 2019 4:37 AM by 3836116

    Error while expdp/impdp in Oracle 12C environment




      Recently we are getting below error on schema backup job (expdp/impdp). After reading few blogs about below error and they recommend to increase SGA size.


      UDE-31623: operation generated ORACLE error 31623

      ORA-31623: a job is not attached to this session via the specified handle

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

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

      ORA-06512: at line 1



      Not sure to do the same as it is production environment. Please help me in fixing the same.