ORA-22866问题的解决
来源:互联网 发布:linux c 多线程服务器 编辑:程序博客网 时间:2024/04/29 04:33
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.
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.
- ORA-22866问题的解决
- ORA-01830问题的解决
- ORA-01830问题的解决
- ORA-27092问题的解决
- ora-04091问题的解决
- ora-27054问题的解决
- ORA-14452问题的解决
- ora-01102问题的解决
- ora-01102问题的解决
- ORA-01092问题的解决
- 解决ora-12154的问题
- ora-03206问题的解决
- ora-01578问题的解决
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决(及ORA-15100和ora-1031)
- oracle exp ORA-31600和ORA-00942问题的解决
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决
- Oracle ORA-01078 ORA-01565 ORA-17503 ORA-15077问题的解决
- ora-01033 一个小问题的解决
- 二极管的特性与应用
- 最新JBoss jBPM 3.1 开始指南之一---下载并运行JBoss jBPM
- COM组件技术
- LCD驱动编写小节
- Linux 2.4.x内核软中断机制
- ORA-22866问题的解决
- 突然想写blog了
- 水和鱼完整的故事
- RUP中的几种Iteration pattern(一):Incremental Lifecycle
- xmlBean资料文档收集
- 还是奔驰车牛
- 从今天开始学习了
- 使用C#创建webservice及三种调用方式
- Introduction to Process Definition and Process Improvement -by Jim D. Hart