修改Oracle数据库字符集步骤

select userenv('language') from dual;
USERENV('LANGUAGE')
------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8

2、修改参数

SQL>shutdown immediate
SQL>startup mount

alter system enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;
SQL>alter database open;

3、更改字符集，并跳过对超集的检查

alter database character set internal_use zhs16gbk;
#alter database character set INTERNAL_CONVERT ZHS16GBK;
#alter database character set zhs16gbk;

4、重启数据库

shutdown immediate
startup

5、确认字符集已更改

select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK