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:

Goal

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?

Solution

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