oracle修改字符集

查询oracle字符集select * from nls_database_parameters where parameter='NLS_CHARACTERSET
首先sqlplus登录 例如：database 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
强行修改（如果正常不行就强行修改）
alter database character set internal_use utf8;

shutdown immediate;

startup; (重开正常oracle)