ORA-01792: maximum number of columns in a table or view is 1000
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
LFI-00132: Record length string is greater than max length of string.
ORA-29760: instance_number parameter not specified
ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
ORA-02423: schema name does not match schema authorization identifier
ORA-26046: REF column string expects scoped table name string; user passed in string.
ORA-40253: no target counter examples were found
PLS-00586: a static method cannot declare a parameter named SELF
ORA-26054: Direct Path Context prepared for a different mode than operation requested.
NMP-00004: SNMP variable is read only
DRG-11801: Continue
ORA-16006: audit_trail destination incompatible with database open mode
ORA-15182: ASMLIB [string] version mismatch, oracle version [string]