select v$nls_parameters where parameter = 'NLS_CHARACTERSET';
to KingSunSha(弱水三千): 我说的不是这个字符集,因为我的两个oracle的'NLS_CHARACTERSET'是一样的,但一个可以用clob另一个不能.
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. 查了一下资料,找不到特别的方向,看到有一个参数是启动参数里没有的, select v$nls_parameters where parameter = 'NLS_NCHAR_CHARACTERSET'; 应该是national characterset的设置,你看看两个数据库是不是不同
to KingSunSha(弱水三千): 还是不行,两个oracle的'NLS_NCHAR_CHARACTERSET'也是一样.
where parameter = 'NLS_CHARACTERSET';
我说的不是这个字符集,因为我的两个oracle的'NLS_CHARACTERSET'是一样的,但一个可以用clob另一个不能.
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.
查了一下资料,找不到特别的方向,看到有一个参数是启动参数里没有的,
select v$nls_parameters
where parameter = 'NLS_NCHAR_CHARACTERSET';
应该是national characterset的设置,你看看两个数据库是不是不同
还是不行,两个oracle的'NLS_NCHAR_CHARACTERSET'也是一样.