Oracle 10g修改数据库字符集

查看当前字符集引用
SQL> select * from nls_database_parameters where parameter like "%SET%"; PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               WE8ISO8859P1
NLS_NCHAR_CHARACTERSET         AL16UTF16 引用
SQL> select userenv（"language"） from dual; USERENV（"LANGUAGE"）
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P1尝试直接修改字符集引用
SQL> ALTER DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE CHARACTER SET ZHS16GBK
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set采用Oracle内部命令修改字符集（注意：此流程仅用于测试，在Oracle 10g中建议用CSALTER修改！
）引用
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started. Total System Global Area 167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              62916852 bytes
Database Buffers          100663296 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;                         System altered. SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; System altered. SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0; System altered. SQL> ALTER DATABASE OPEN; Database altered. SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE zhs16gbk; Database altered.
修改时alert日志显示：Completed: ALTER DATABASE OPEN
Tue May 18 10:56:43 2010
ALTER DATABASE CHARACTER SET INTERNAL_USE zhs16gbk
Tue May 18 10:56:47 2010
Updating character set in controlfile to ZHS16GBK
Synchronizing connection with database character set information
Refreshing type attributes with new character set information
Completed: ALTER DATABASE CHARACTER SET INTERNAL_USE zhs16gbk
查看修改后结果：SQL> select * from nls_database_parameters where parameter like "%SET%"; PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
ZHS16GBK NLS_NCHAR_CHARACTERSET
AL16UTF16SQL> select userenv（"language"） from dual; USERENV（"LANGUAGE"）
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBKOracle 11g备份文件导入10gMySQL 运用存储过程实现主键生成相关资讯 Oracle数据库

Oracle数据库全球化（03月01日）
Oracle数据库日期过滤方法性能比较（02/02/2015 13:20:26）
Oracle数据库安装中端口被占用问题（10/29/2014 07:42:24）

在CentOS 6.6上搭建C++运行环境并（10/10/2015 19:44:40）
Oracle数据库无法使用localhost和（11/14/2014 16:39:10）
Oracle 多数据库的数据同时更新（06/16/2014 21:52:23）

本文评论查看全部评论（0）