3 Replies Latest reply on Jan 4, 2019 6:41 PM by jaramill

    how to avoid ORA-01792?

    Mario Goren



      <dm:error xmlns:dm="http://identifiers.emc.com/vocab/xcp">
      <dm:message>Failed to fetch the process instance.</dm:message>
      [DM_QUERY_E_CURSOR_ERROR]error: "A database error has occurred during the creation of a cursor ('ORA-01792: maximum number of columns in a table or view is 1000')."


      We tryed   alter system set "_fix_control"='17376322:OFF';  but we get:


      ORA-32017: failure in updating SPFILE

      ORA-02097: parameter cannot be modified because specified value is invalid


      How to solve this?