ORA-01792 maximum number of columns in a table or view is 1000 FROM mtl_parameters

Symptoms:-

Concurrent program completed warning with   “ORA-01792 maximum number of columns in a table or view is 1000 FROM mtl_parameters” this reason.

Solution:-

SQL> alter session set “_fix_control”=’17376322:OFF’; 

or at system level : 
SQL> alter system set “_fix_control”=’17376322:OFF’; 
  • October 16, 2017 | 14 views
  • Comments