ORA-01792: maximum number of columns in a table or view is 1000

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-01792：表或视图中的最大列数为1000,
.原因：尝试创建具有超过1000个列的表或视图，或者向表或视图添加更多列，将其推入超过最大允许限制1000.请注意，表中未使用的列将计入1000列限制。,
.操作：如果错误是CREATE命令的结果，则减少命令中的列数，然后重新提交。如果错误是ALTER TABLE命令的结果，则有两个选项：1）如果表包含未使用的列，请在添加新列之前执行ALTER TABLE DROP UNUSED COLUMNS来删除它们; 2）减少命令中的列数，然后重新提交。,
.

aiaiDBA

13718043309

010-86462881

ORA-01792: maximum number of columns in a table or view is 1000

1 个回答

相似问题