aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

KUP-04108: unable to reread file string

KUP-04108: unable to reread file string
Cause: The query that is executing requires that a data source for an external table be read multiple times. However, the data source is a sequential device that cannot be reread. Examples of this type of data source is a tape or pipe.
Action: There are a few ways around this problem. One is to rewrite the query so that the external table is referenced only once. Another option is to move the data source to a rereadable device such as a disk file. A third option is to load the data for the external table into a temporary table and change the query to reference the temporary table.

请先 登录 后评论

1 个回答

小智
KUP-04108:无法重新读取文件串,
.原因:正在执行的查询需要多次读取外部表的数据源。但是,数据源是无法重新读取的顺序设备。这种类型的数据源的示例是磁带或管道。,
.行动:有几个方法来解决这个问题。一个是重写查询,使外部表只被引用一次。另一个选择是将数据源移动到可重新读取的设备,如磁盘文件。第三个选项是将外部表的数据加载到临时表中,并将查询更改为引用临时表。,
.
请先 登录 后评论