Friday, May 29, 2015

Fix for (12c only): ORA-01792: MAXIMUM NUMBER OF COLUMNS IN A TABLE OR VIEW IS 1000



SOLUTION

The workaround is to set "_fix_control"='17376322:OFF'
SQL> alter session set "_fix_control"='17376322:OFF';
or at system level :
SQL> alter system set "_fix_control"='17376322:OFF';

OR

Apply Patch 19509982 if available for your DBVersion and Platform
Post a Comment