10g中如何修改数据库字符集-4

10g 中如何修改字符集？

对于oracle10g，已经完全跟8i 9i不一样了，不再使用alter database  命令，metalink解释如下:

Using the "ALTER DATABASE CHARACTER SET"command in 8i or 9i and CSALTER in 10g and up.

首先我们来看下scan.txt的内容：

[Scan Summary]

All character type data in the data dictionary areconvertible to the new character set

All character type application data are convertible tothe new character set

[Data Dictionary Conversion Summary]

Datatype                    Changeless      Convertible       Truncation            Lossy

--------------------- -------------------------------- ---------------- ----------------

VARCHAR2                     1,922,959                0                0                0

CHAR                             1,104                0                0                0

LONG                           146,008                0                0                0

CLOB                            22,544            1,215                0                0

VARRAY                              24                0                0                0

--------------------- -------------------------------- ---------------- ----------------

Total                       2,092,639            1,215                0                0

Total in percentage             99.942%           0.058%           0.000%           0.000%

The data dictionary can be safely migrated using theCSALTER script

[Application Data Conversion Summary]

Datatype                    Changeless      Convertible       Truncation            Lossy

--------------------- -------------------------------- ---------------- ----------------

VARCHAR2                        28,702                2                0                0

CHAR                                 0                0                0                0

LONG                                 0                0                0                0

CLOB                                 0                0                0                0

VARRAY                           1,575                0                0                0

--------------------- -------------------------------- ---------------- ----------------

Total                           30,277                2                0                0

Total in percentage             99.993%           0.007%           0.000%           0.000%

[Distribution of Convertible, Truncated and Lossy Databy Table]

USER.TABLE                                              Convertible       Truncation            Lossy

------------------------------------------------------------------ ---------------- ----------------

MDSYS.SDO_COORD_OP_PARAM_VALS                                   200                0                0

MDSYS.SDO_GEOR_XMLSCHEMA_TABLE                                    1                0                0

MDSYS.SDO_STYLES_TABLE                                          78                0                0

MDSYS.SDO_XML_SCHEMAS                                             3                0                0

ROGER.HT01                                                       2                0                0

SYS.METASTYLESHEET                                              80                0                0

SYS.RULE$                                                        1                0                0

SYS.WRH$_SQLTEXT                                               381                0                0

SYS.WRH$_SQL_PLAN                                               347                0                0

SYS.WRI$_DBU_FEATURE_METADATA                                    98                0                0

SYS.WRI$_DBU_FEATURE_USAGE                                        7                0                0

SYS.WRI$_DBU_HWM_METADATA                                        19                0                0

------------------------------------------------------------------ ---------------- ----------------