My Oracle Support Banner

Limitation On Number Of Columns Sales_data Table - Not Allowing Series Creation Receiving ORA-01792 (Doc ID 1359843.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.1 and later
Information in this document applies to any platform.


Release 7.3.1 and above

Customer has a business requirement to lag some series. And to support it using rolling profile, they need to create series with update field on sales_data table. They reached 999 columns (our seeded sales_data contains 530 columns) and they are now getting error ORA-01792 in Business Modeler.

More specifically, the error reads:

ORA-01792: maximum number of columns in a table or view is 1000
Cause: An attempt was made to create a table or view with more than 1000 columns, or to add more columns to a table or view which pushes it over the maximum allowable limit of 1000. Note that unused columns in the table are counted toward the 1000 column limit.
Action: If the error is a result of a CREATE command, then reduce the number of columns in the command and resubmit. If the error is a result of an ALTER TABLE command, then there are two options: 1) If the table contained unused columns, remove them by executing ALTER TABLE DROP UNUSED COLUMNS before adding new columns; 2) Reduce the number of columns in the command and resubmit.

Which columns can be safely dropped?
Or is there another suggestion?


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

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