以下是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.