将oracle字符集改成GB18030
(2011-06-29 14:16:05)
转载▼
标签:
数据库
字符集
oracle
gb18030
ora-12712
it
1、以管理员身份进入数据库
$sqlplus /nolog
conn sys as sysdba
password:xxxxxxxx
2、修改字符集
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET ZHS32GB18030;
当字符集小于当前字符集的时候,这里会出现一个错误。
(!!!!cORA-12712: new character set must be a superset of old character set )
继续用下面指令,照样可以正常替换。只是有些表中的中文字符没法用了。
ALTER DATABASE character set INTERNAL_USE ZHS32GB18030;
3、重新启动数据库
SHUTDOWN;
STARTUP;
4、设置环境变量
Windows:set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS32GB18030
Linux: export NLS_LANG='SIMPLIFIED CHINESE_CHINA.ZHS32GB18030'