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博客 ” ，链接：https://blog.itpub.net/29371470/viewspace-2126805/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
sql server行列转换案例
下一篇：
oracle基于cbo成本计算方式说明
请登录后发表评论
登录
全部评论
