Limitation On Number Of Columns Sales_data Table - Not Allowing Series Creation
Last updated on MARCH 08, 2017
Applies to:Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 23-Oct-2013 ***
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. (rdbms is 11g)
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms