Oracle 修改字符集

conn sys/密码 as sysdba; 
shutdown immediate; (把database停了)

startup mount; (把database重开去可更改情況)

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 utf8;
OR （如果上面报错 则使用下面的 添加 internal_use )
alter database character set internal_use utf8;

/*
ALTER DATABASE CHARACTER SET ZHS16GBK;
OR
ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
*/

shutdown immediate;

startup;