数据库的Imp/Exp

[复制链接]
查看11 | 回复1 | 2006-4-17 13:46:34 | 显示全部楼层 |阅读模式
在操作是的提示如下:
在创建表时:
ORA-22866:默认字符集具有不同的宽度; ???
怎么处理!!!
[email protected]
[email protected]
回复

使用道具 举报

千问 | 2006-4-17 13:46:34 | 显示全部楼层
在建表时由于表上有BLOB或CLOB列造成以上错误的,通常是IMP带有CLOB列的表时候报这个错误的!

以下是METALINK的解决方法,望参考!
Problem Description -------------------
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 widthCause: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 of8.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.
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行