ORA-01792: maximum number of columns in a table or view is <>

ORA-01792 appears to be a logical error which means you are attempting to create a table or view with more than 1000 columns or adding columns to an existing table or view resulting in 1000+ columns, however if you are on 12cR1 and above and receiving ORA-01792 from a Select statement then this can be due to unpublished bugs:-

  • Bug 19653859 – CI BACKPORT OF BUG 19509982 FOR INCLUSION IN DATABASE BP 12.1.0.2.2.
  • Bug 19509982 – DISABLE FIX FOR RAISING ORA-1792 BY DEFAULT.

The workaround is either to apply patch 19509982 or to disable fix control 17376322 :-

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.