ORA-22866问题的解决

最新推荐文章于 2022-12-09 17:29:57 发布

wonder4

最新推荐文章于 2022-12-09 17:29:57 发布

阅读量2.1k

点赞数

分类专栏： Oracle技术文章标签： character database table action import oracle

本文链接：https://blog.csdn.net/wonder4/article/details/906202

版权

Oracle技术专栏收录该内容

165 篇文章 2 订阅

订阅专栏

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.