oracle字符集修改
oracle字符集修改
以dba身份登录,详细可查看上一篇文章oracle在docker下的安装配置
命令如下:
select userenv('language') from dual; //查看字符集
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 internal_use utf8;//改为utf-8
// alter database character set internal_use zhs16gbk; 改为gbk
shutdown immediate;
startup;