OCI-60600
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 three options:
- If the table contained unused columns, remove them by executing ALTER TABLE DROP UNUSED COLUMNS before adding new columns;
- Reduce the number of columns in the command and resubmit.
- Increase compatability to 23.1