Sat Apr 28 21:03:25 2007
alter database character set INTERNAL_CONVERT ZHS16GBK
Sat Apr 28 21:03:42 2007
Updating character set in controlfile to ZHS16GBK
Synchronizing connection with database character set information
SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
SYS.ATTRIBUTE_TRANSFORMATIONS$ (XSL_TRANSFORMATION) - CLOB representation altered
SYS.RULE$ (CONDITION) - CLOB representation altered
SYS.SCHEDULER$_EVENT_LOG (ADDITIONAL_INFO) - CLOB representation altered
SYS.WRI$_DBU_FEATURE_METADATA (INST_CHK_LOGIC) - CLOB representation altered
SYS.WRI$_DBU_FEATURE_METADATA (USG_DET_LOGIC) - CLOB representation altered
SYS.WRI$_DBU_HWM_METADATA (LOGIC) - CLOB representation altered
XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
Sat Apr 28 21:03:53 2007
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: D:ORACLEPRODUCT10.2.0ORADATATESTREDO01.LOG
Sat Apr 28 21:03:54 2007
MDSYS.SDO_COORD_OP_PARAM_VALS (PARAM_VALUE_FILE) - CLOB representation altered
MDSYS.SDO_COORD_OP_PARAM_VALS (SYS_NC00008$) - CLOB representation altered
MDSYS.SDO_STYLES_TABLE (DEFINITION) - CLOB representation altered
MDSYS.SDO_XML_SCHEMAS (XMLSCHEMA) - CLOB representation altered
MDSYS.SDO_GEOR_XMLSCHEMA_TABLE (XMLSCHEMA) - CLOB representation altered
Refreshing type attributes with new character set information
Completed: alter database character set INTERNAL_CONVERT ZHS16GBK

Sat Apr 28 21:04:00 2007
alter database national character set INTERNAL_CONVERT AL16UTF16
Completed: alter database national character set INTERNAL_CONVERT AL16UTF16

原来就用这个就可以自由修改字符集了,真爽