11g升級到Oracle 12c碰到的問題(11g中不存在問題) - ORA-01792

datapeng發表於2016-10-20

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

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29371470/viewspace-2126805/,如需轉載,請註明出處,否則將追究法律責任。

相關文章