Database Error Messages

OCI-05080

maximum number of columns in a sharded table in a system or composite sharding environment is string

Cause

An attempt was made to create a sharded table with too many columns, or to add more columns to a sharded table which pushes it over the maximum allowable limit. Note that unused columns in the table are counted toward the total 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.