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

    how to avoid ORA-01792?

    user13515475

      running 11.2.0.4

       

      <dm:error xmlns:dm="http://identifiers.emc.com/vocab/xcp">
      <dm:status>500</dm:status>
      <dm:code>E_ECM_PROCESS_FETCH_FAILED</dm:code>
      <dm:message>Failed to fetch the process instance.</dm:message>
      <dm:details>
      [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')."
      </dm:details>
      </dm:error>

       

      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?