ORA-28562: Heterogeneous Services data truncation error ORACLE 报错 故障修复 远程处理
文档解释
ORA-28562: Heterogeneous Services data truncation error
Cause: A select operation was attempted with an insufficient data buffer to satisfy the request.
Action: Contact your DBA to verify whether your gateway initialization parameter HS_KEEP_REMOTE_COLUMN_SIZE is set appropriately based on your requirement. If it is, make sure the sizes of bind parameters are sufficient. If the problem persists, contact Oracle Support Services.
ORA-28562: Heterogeneous Services data truncation error 用于指出数据库在将来自外部数据源的数据插入Oracle数据库表的时候可能会发生数据截断的可能性。
官方解释
常见案例
一般处理方法及步骤
1.检查源表中的数据列,确定其字符长度及字段类型是否比目标表中长/宽。
2.如果源列的类型及长度比目标列的长度大,则缩短源列的定义,或更改目标表中字段的宽度,以使它们相匹配。
3.一旦源列定义/目标列定义匹配,再进行复制操作,就不会发生ORA-28562异常了。