ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.

ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.
Cause: An attempt was made to convert CLOB to CHAR, where the LOB size was bigger than the buffer limit for CHAR types or the CHAR buffer was not big enough to hold all data after character set conversion.
Action: Do one of the following:
* Make the LOB smaller before performing the conversion. for example, by using SUBSTR on CLOB

* Use DBMS_LOB.SUBSTR to convert CLOB to CHAR.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:55

ORA-64203：目标缓冲区太小，无法在字符集转换后保存CLOB数据。,
.原因：试图将CLOB转换为CHAR，其中LOB大小大于CHAR类型的缓冲区限制，或者CHAR缓冲区不足以在字符集转换后保存所有数据。,
.操作：执行以下操作之一：,
.*在执行转换之前使LOB更小。例如，通过使用CLOB上的SUBSTR,
.,
.*使用DBMS_LOB.SUBSTR将CLOB转换为CHAR。,
.,
.

aiaiDBA

13718043309

010-86462881

ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.

1 个回答

相似问题