MetalinkYou 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.
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.
是不是把它改的再高一些,如compatible = 8.1.5我打算下半夜3,4点修改.