My Oracle Support Banner

ORA-01792 While Adding A Column To The Table Even With Less Number Of Columns (Doc ID 2116118.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Jul-2017***

Symptoms

ORA-01792 even when columns in the table has not reached max limit 1000, as shown in desc and dba_tab_columns

But we can find many SYS_NC columns in table. Since the number of columns is reach table limit, this affect the future schema change.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.