oracle修改字符集

---修改字符集
sqlplus as sysdba --登录数据库dba权限
alter database open;
alter database character set internal_use ZHS16GBK; --设置字符集值
select userenv('language') from dual; --查看数据库的字符集
shutdown --关闭数据库
startup --启动数据库
alter system enable restricted session;
alter system set job_queue_processes=0;
shutdown immediate;
startup
alter system disable restricted session;
select userenv('language') from dual; --最后查看数据库的字符集