11g升级到Oracle 12c碰到的问题(11g中不存在问题) - ORA-01792

Oracle suggest to alter the query and/or view definitions to avoid the error. However in cases where the SQL cannot be adjusted then the checking can be disabled by:  

SQL> alter system set "_fix_control"='17376322:OFF';

Alternatively an interim patch for this fix (patch 19509982) can be applied to disable the error by default.

For details:
Bug 19509982 Disable raising of ORA-1792 by default
Select Statement Throws ORA-01792 Error

http://dba.stackexchange.com/questions/128621/understanding-ora-01792-maximum-number-of-columns-in-a-table-or-view-is-1000  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-2126716/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-2126716/