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

Last updated on FEBRUARY 19, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

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.

	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

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