标题: oracle数据库如何更改字符集 [打印本页] 作者: caixuqad 时间: 2020-7-6 17:56 标题: oracle数据库如何更改字符集 下面为更改oracle字符集的步骤：
conn /as sysdba
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;
ALTER DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
shutdown immediate;
startup
--最后查看oracle数据库字符集是否更改正确
select userenv ('language') from dual;
