Home
TeamConnect
TeamConnect Solutions
TeamConnect Enterprise
How to resolve the error: ORA-01792 maximum number of columns in a table or view is 1000

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

Workflow Automation

Corporate Legal & Claims

Governance, Risk & Compliance

Human Resources Compliance

How to resolve the error: ORA-01792 maximum number of columns in a table or view is 1000

Last updated
Save as PDF

Error Code: "ORA-01792: maximum number of columns in a table or view is 1000" issue is a bug in oracle 12c.

Please install oracle patch 19509982 to resolve this issue (or) As a work around, you can run the following query in the database as an administrator to disable this error.

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

Additional references:

Bug 19509982 Disable raising of ORA-1792 by default (https://support.oracle.com/epmos/faces/DocumentDisplay?id=19509982.8)
Select Statement Throws ORA-01792 Error (https://support.oracle.com/epmos/faces/DocumentDisplay?id=1951689.1)