建立带有clob类型的字段时都会出现"ORA-22866 "错误

系统平台: window2003
数据库版本:oracle8.17
问题: 建立带有clob类型的字段时都会出现"ORA-22866 默认字符集具有不同的宽度",普通字段则好好的.不知什么原因,特来救助.
---------------------------------------------------------------

Metalink

You are attempting to create a table with a CLOB column, and it fails
with the following error:

ORA-22866: default character set is of varying width
Cause: A character LOB was defined but the default character set
is not fixed width.
Action: Ensure that the character set is of fixed width before
defining character LOBs.

This may also occur on import when importing from a table that has a
CLOB column.

Solution Description
--------------------

The compatible parameter for your database is set to 8.0.5 (or lower).
Edit the init.ora parameter file with a compatible parameter of
8.1.0 or higher.

Explanation
-----------

Your database has a character set of UTF8, a variable width character set.
In versions previous to Oracle8i, this restricted the use of CLOB datatypes.

---------------------------------------------------------------

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus