本文介绍Oracle 10g中如何通过CSALTER脚本进行字符集的转换，包括扫描文件的内容解析，以及数据字典和应用程序数据转换的总结。
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
------------------------------------------------------------------ ---------------- ----------------
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
