oracle修改字符集

1.查询当前字符集

SELECT parameter, value
  FROM v$nls_parameters
 WHERE parameter = 'NLS_CHARACTERSET';
 
select userenv('language') from dual;

2.开库至mount状态并设置session

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;

3.修改字符集

SQL> ALTER DATABASE CHARACTER SET AL32UTF8;
ALTER DATABASE CHARACTER SET AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
提示我们的字符集：新字符集必须为旧字符集的超集，跳过超集检查做更改：

ALTER DATABASE character set INTERNAL_USE AL32UTF8;

4.重新启动数据库

shutdown immediate;
startup

5.查看更改后的字符集编码

select userenv('language') from dual;