ORA-30659: too many locations specified for external table

ORA-30659: too many locations specified for external table
Cause: An attempt was made to create an External Organized table with more than the maximum allowable (32767) locations specified.
Action: Don't do that, use fewer location clauses. Either consider concatenating the input files, or, creating two external tables with the input files split between them.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-30659：为外部表指定的位置太多,
.原因：试图创建一个超过指定的最大允许（32767）位置的外部组织表。,
.操作：不要这样做，使用较少的位置子句。要么考虑连接输入文件，要么创建两个外部表，其中输入文件在它们之间拆分。,
.

aiaiDBA

13718043309

010-86462881

ORA-30659: too many locations specified for external table

1 个回答

相似问题