下面为更改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;
发表于 2020-7-6 17:56:58
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
楼主
